Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
|
developer:database_backups [2009/12/19 06:44] henri |
developer:database_backups [2009/12/19 07:01] henri |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== Database Backups ====== | ====== Database Backups ====== | ||
| \\ \\ | \\ \\ | ||
| + | |||
| ===== MySQL ===== | ===== 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. | 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 ==== | ==== Helpful Database Backup Links ==== | ||
| Line 11: | Line 20: | ||
| * [[http://www.bombich.com/software/docs/CCCHelp/CCCHelp.html?page=advsettings|CCC Pre Backup Script]] (includes dumps of MySQL, OpenDirectory and Server Admin configurations) | * [[http://www.bombich.com/software/docs/CCCHelp/CCCHelp.html?page=advsettings|CCC Pre Backup Script]] (includes dumps of MySQL, OpenDirectory and Server Admin configurations) | ||
| \\ \\ | \\ \\ | ||
| - | |||