Edgewall Software

Version 33 (modified by Ryan J Ollos, 7 years ago) ( diff )

Add info for MySQL.

This page documents the 1.4 (latest stable) release. Documentation for other releases can be found here.

Trac Backup

Trac backups are simply a copied snapshot of the entire project environment directory, including the database. Backups can be created using the hotcopy command in trac-admin.

Note: Trac uses the hotcopy nomenclature to match that of Subversion, to make it easier to remember when managing both Trac and Subversion servers.

Creating a Backup

To create a backup of a live TracEnvironment simply run:

$ trac-admin /path/to/projenv hotcopy /path/to/backupdir

trac-admin will lock the database while copying.

The resulting backup directory is safe to handle using standard file-based backup tools like tar or dump/restore.

Please note, the hotcopy command will not overwrite a target directory and when such exists, the operation ends with an error: Command failed: [Errno 17] File exists: This is discussed in #3198.

Restoring a Backup

To restore an environment from a backup, stop the process running Trac, ie the Web server or tracd, restore the contents of your backup (path/to/backupdir) to your project environment directory and restart the service.

If you are using a database other than SQLite, you'll need to restore the database from the dump file.

To restore a PostgreSQL database backup, use the command:

$ psql -U <user> -d <database> -f postgresql.dump

The <database> option is the same as the database connection string in the [trac] database option of trac.ini.

Similarly, for MySQL:

$ mysql -u <user> -p <database> < mysql.dump

See also: TracAdmin, TracEnvironment, TracGuide, TracMigrate

Note: See TracWiki for help on using the wiki.