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. In addition, link to the script listed below also contains an example of how to dump Mac OS X server settings.
There are two obvious approaches to scheduling the dumps of this data. Firstly, you may use the commands listed withi a pre-action script attached to a scheduled LBackup configuration to generate an Archive of the Open Directory and / or Server Settings. Another approach is to run these commands with a scheduling utility.
Regardless, you should 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)