Differences

This shows you the differences between the selected revision and the current version of the page.

--- developer:database_backups 2009/11/02 16:23
+++ developer:database_backups 2009/12/19 20:03 current
@@ Line 1: / Line 1: @@
 ====== Database Backups ======
+\\ \\
-===== Helpful Database Backup Links =====
+===== MySQL =====
-  * [[http://www.sysadmin.md/opensource-scripts-to-backup-mysql-databases.html|MySQL Backup Scripts]]
+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 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.
 \\ \\
+==== Helpful Database Backup Links ====
+  * [[http://www.sysadmin.md/opensource-scripts-to-backup-mysql-databases.html|MySQL Backup Scripts]]
+  * [[http://sourceforge.net/projects/automysqlbackup/|automysqlbackup]] (great little utility)
+  * [[http://www.bombich.com/software/docs/CCCHelp/CCCHelp.html?page=advsettings|CCC Pre Backup Script]] (includes dumps of MySQL, OpenDirectory and Server Admin configurations)
+\\ \\