vBulletin Database Backup

I’m maintaining a pretty big forum. It has a great amount of traffic, AND huge database size. Right now, it has a remote backup server. The optimization is always challenging. Anyway, vBulletin upgrade process was easy. The forum I maintain used vBulletin 3.6.x when it was firstly installed. Right now, it’s using the latest stable release.

The first thing I did before upgrading is to backup its database. Using web-based database management tool like phpMyAdmin is easy. We can export and store it in minutes. BUT, in some cases, it takes more time if we have a large database. So, I use the other method: using the backup script.

When we download vBulletin, there is a backup script included in the distribution. It’s under do_not_upload directory. The file is vb_backup.sh. The first thing we need to do is to edit this script, to locate the configuration file. After that, we only need to execute this command: ./vb_backup.sh backup

It will generate a backup file using this pattern: databasename-dd-mm-yy.sql.gz. Just keep the file into the safe place (outside public directory always recommended), and start upgrading. All done.