3.10. Backups

3.10.1. Database

Here are some sample commands you could use to backup your database, depending on what database system you're using. You may have to modify these commands for your particular setup. Replace the $VARIABLEs with appropriate values for your setup.

3.10.1.1. MySQL

mysqldump --opt -u $USERNAME -p $DATABASENAME > backup.sql

See the mysqldump documentation for more information on mysqldump.

Todo

Mention max_allowed_packet? Convert this item to a bug on checkin.

3.10.1.2. PostgreSQL

pg_dump --no-privileges --no-owner -h localhost -U $USERNAME > bugs.sql

3.10.2. Bugzilla

The Bugzilla directory contains some data files and configuration files which you would want to retain. A simple recursive copy will do the job here.

cp -rp $BUGZILLA_HOME /var/backups/bugzilla

---

This documentation undoubtedly has bugs; if you find some, please file them here.