.. _backups:

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
-----

:command:`mysqldump --max-allowed-packet=32M -u $USERNAME -p $DATABASENAME > backup.sql`

The value for :command:`max-allowed-packet` should be the value you've set in
your :ref:`MySQL configuration file <mysql>`, and should be larger than the
largest attachment in your database. See the
`mysqldump documentation <http://dev.mysql.com/doc/mysql/en/mysqldump.html>`_
for more information on :file:`mysqldump`.

PostgreSQL
----------

:command:`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.

:command:`cp -rp $BUGZILLA_HOME /var/backups/bugzilla`