This is an old revision of the document!
Database Backups
MySQL
One option for MySQL database backups is to have a replica and then dump from the replica. This allows you to leave the primary database active and accessible during the dump.
Mac OS X Server
Below is a link to a script which you may use to create an archive of the Open Directory on a Mac OS X server. One option is to use the commands listed in the link in a pre-action script to generate an Archive of the Open Directory. Another option is to run these commands with a scheduling utility. Either way, you will need to ensure that the archives are stored within a source directory for your backup.
Helpful Database Backup Links
- automysqlbackup (great little utility)
- CCC Pre Backup Script (includes dumps of MySQL, OpenDirectory and Server Admin configurations)