View Single Post
  #8  
Old 16-09-2005, 16:51
Nicke's Avatar
Nicke Nicke is offline
Administrator [1]
Senior Elite Member
 
Join Date: May 2002
Location: Patong beach, Thailand
Age: 37
Posts: 10,031
Send a message via ICQ to Nicke
Many servers have PHPMyAdmin of whatever it was called, be be beware, due to timeout limits in HTTP, it can result in unfinished backups.

The best things is to do this from shell using mysqldump tool.

If you store the database in a database named forum, you just have to do

mysqldump -u username -p forum > db-backup.sql

-p will prompt for the password.

Then you can download the file to your own harddisk. I just purchased a backup server and I use rsync to copy files to another harddisk on another server.

To backup the forum, I just need a copy of the database and the directory containing the attachments. (Attachments can be in the file system or in the database, vBulletin support both methods.)
__________________
PhuketThailand PhotosMai Thai Bar
Reply With Quote