Backups

*******

 

 

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.

 

 

MySQL

-----

 

**mysqldump --max-allowed-packet=32M -u $USERNAME -p $DATABASENAME >

backup.sql**

 

The value for **max-allowed-packet** should be the value you've set in

your MySQL configuration file, and should be larger than the largest

attachment in your database. See the mysqldump documentation for more

information on "mysqldump".

 

 

PostgreSQL

----------

 

**pg_dump --no-privileges --no-owner -h localhost -U $USERNAME >

bugs.sql**

 

 

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.