Database Backups

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.

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 example listed in the scripts within a pre-action script attached to an already scheduled LBackup configuration. Another approach is to run these commands/script(s) with scheduling utility.

Regardless, you should ensure that the archives are stored within a source directory for your backup.

• MySQL Backup Scripts
• automysqlbackup (great little utility)
• CCC Pre Backup Script (includes dumps of MySQL, OpenDirectory and Server Admin configurations)