The following scripts are supplied to illustrate how it is possible to automate the backup of CatDV preferences and a MySQL database. They are free to use and modify but are provided for use at your own risk. Please consult a systems administrator if you are in any doubt about your backup and recovery strategy.
This tutorial is focused on OSX environments only.
As with any backup strategy there is no substitute for regular testing that backups are stored and can be recovered correctly. Disaster recovery tests are strongly recommended.
Knowledge of scripting will be needed to adapt these scripts to suit a specific environment or business needs.
Each script creates a folder on the Desktop called CatDVBackups with the sub-folders:
serverprefs clientprefs workerprefs database
It then copies and date stamps the files into the corresponding subfolder.
There are comments in each script to help indicate what each section does and suggestions on where modifications can be made. It is possible to automate these scripts to run to a schedule using task scheduling features within OSX, below are links indicating how to do this:
Launchd in Macintosh environments is described here
Macintosh shell script
Copy and paste the text of the script section at the bottom of this page into a text file and save it as catdv_backup.sh on the Desktop
or download the file here and rename the extension to .sh CatDV_backup.txt
Open terminal and the type
cd Desktop
chmod +x catdv_backup.sh
this makes the file executable
to run type
./catdv_backup.sh
in the terminal and hit enter
If the file name is changed to catdv_backup.command the command can be run in future by double clicking the file – please note it must be run once as a .sh before this will work
for automation it should be left as a .sh extension but a copy can be made and set to the .command extension for manual use.
#!/bin/sh # shell script to back up key CatDV preferences files # -- Set the window title -- # title='shell script to back up key CatDV preferences files' # echo "33]0;$title07" # -- Set the paths and folder names -- # to change the name of the backup folder Type the name below in place of CatdvBackups # (no more than 30 characters alphanumeric with no white space) # (this will be automatically substituted throughout the rest of the script) Bfolder='CatDV_Backups' # to modify the location of your backup folder change the path by replacing # the string %HOMEPATH%Desktop with the preferred path # (this will be automatically substituted throughout the rest of the script) Bpath='Desktop' # set the path to your mysql installation MYSQLpath=/usr/local/mysql/bin/ #set the user name for the logged on user $USERNAME=alastair # echo the output folder echo $HOME echo $Bpath echo $Bfolder echo $Bpath/$Bfolder # Create Directories at backup target # Change folder to Backup path cd $HOME cd $Bpath pwd # Make a folder named by the variable $Bfolder mkdir $Bfolder # Change folder to $Bfolder and then make sub folders cd $Bfolder mkdir serverprefs mkdir clientprefs mkdir workerprefs mkdir Database # Copy the files and date + timestamp the backups -- cp /usr/local/catdvServer/catdv.properties /CatDV_Backups/serverprefs/catdv`date +%Y-%m-%d-%H.%M`.properties cp $HOME/Library/Application Support/worker.xml /$HOME/Desktop/CatDV_Backups/workerprefs/worker`date +%Y-%m-%d-%H.%M`.xml cp /Users/$USERNAME/Library/Application Support/workset.xml /$HOME/Desktop/CatDV_Backups/workerprefs/workset`date +%Y-%m-%d-%H.%M`.xml cp /Users/$USERNAME/Library/Preferences/CatDV Preferences /$HOME/Desktop/CatDV_Backups/clientprefs/CatDV`date +%Y-%m-%d-%H.%M` Preferences # Backup the mysql database and date + timestamp the backups -- /usr/local/mysql/bin/mysqldump -u catdvadmin -pcatdv catdv > /$HOME/Desktop/CatDV_Backups/Database/backup-`date +%Y-%m-%d`.sql