vBulletin Manual - Database Backup

Database Backup

To perform a backup of your database, you can go to Maintenance > Database Backup.

Warning:

Due to limitations with PHP, backups may not be complete on larger databases. Please ensure that the final line of your backup contains:

 ### VBULLETIN DATABASE DUMP COMPLETED ###

If it does not, we recommend backing up using SSH and mysqldump.

You will be presented with a screen similar to this:

Here you are presented with two methods of backing up:

Database tables to include in backup – this will output a backup of the selected tables directly to you.
Backup database to a file on the server – this will output a backup of all tables in the database to the specified file on the server.
Note:
This file must be writeable by the user that PHP is running as (usually the web server). This can generally be accomplished by using chmod 0777 on the directory you wish to write to.

Note:

At this time, vBulletin does not provide any means to import a backup in the control panel. We recommend using SSH and mysql. If this is not possible, you may try a tool such as phpMyAdmin.

Links from this section:

CSV Backup of a Table

Manual Navigation

Next: vBulletin

Page Top

Home

filburt1	20th Apr 2005, 11:06am
You can back up your database via a reliable SSH command-line-based method. The process is outlined in the Moving Servers page: http://www.vbulletin.com/docs/html/main/moving_servers_backup (moderator: please replace e-mail with complete junk if approved)