Fannie includes a default task for creating MySQL database backups. For other database systems, you're on your own. This document is tailored towards MySQL in a Linux/UNIX environment. Making it work in Windows should be possible though.

Backup Basics

Nothing overly fancy is going on here. Backups are performed using mysqldump. The main advantage is utilizing fannie's configuration so there's one master file with database connection info that all tools and scripts rely on. If you rotate database passwords periodically, that means just one file to update.


Fannie's main install/config page exposes a few configuration options for database backups: Once the configuration is set, just enable and schedule the job nightly.db.backup.php via Fannie Dayend Polling => Scheduled Tasks.

Restoring a Backup

First, if you used compression, decompress the desired backup file. In most graphical environments, that's just double-clicking it. On the command line, try gzip -d <backup file>.

Next, load the backup file. If you're using any sort of GUI tool to manage your MySQL server, just find it's backup/restore option and restore from your backup file. The format's pretty universal, so any tool should handle it. Working on the command line, try mysql -u <mysql username> -p <mysql password> -h <mysql host IP> < <backup file>. Example for clarity: mysql -u root -p secret_passcode -h localhost < is4c_op20120101.sql.