LAMP backups

Posted on by chris.juszak

I recently moved some websites and I’m “re-setting up” my backups. I like to keep rolling daily and monthly backups, so I wrote a small bash script that looks like this:

!/bin/bash
 export BACKUP_ROOT=/root/www-backup
 if [ $1 = "daily" ]; then
    export BACKUP_SUBDIR1=daily
    export BACKUP_SUBDIR2=$(date +\%A)
 elif [ $1 = "monthly" ]; then
    export BACKUP_SUBDIR1=monthly
    export BACKUP_SUBDIR2=$(date +\%B)
 else
   export BACKUP_SUBDIR1=adhoc
   export BACKUP_SUBDIR2=$(date +\%F)
 fi
 export BACKUP_FULLPATH=$BACKUP_ROOT/$BACKUP_SUBDIR1/$BACKUP_SUBDIR2
 echo "Ensuring backup path \"$BACKUP_FULLPATH\" exists"
 mkdir -p $BACKUP_FULLPATH
 echo "Updating httpd.conf backup file in /var/www/conf-backup/"
 /bin/rsync -u /etc/httpd/conf/httpd.conf /var/www/conf-backup/
 echo "Updating files in $BACKUP_FULLPATH (from /var/www)"
 /bin/rsync -ax --delete /var/www/ $BACKUP_FULLPATH/

Then I have a bunch of database backup lines in my crontab that take the general form:

@daily mysqldump --password=dbPass --user=dbUser --host=dbHost --add-drop-table dbName > /var/www/dbName.sql

Finally, I have two other cronjobs that look like this to call the script:

daily /root/www-backup.sh daily
@monthly /root/www-backup.sh monthly

I’ll do something else to occasionally backup the files to another server, but this gets things started.

Side note: During my experimentation (moving from an old server to a new one) I used a small C++ app I wrote to do help with the migration: https://github.com/juszak/LAMPbackup. Writing this in C++ probably seems a little odd (and it is). Bash or Python make more sense. However, I had some other reasons for doing this (mainly using this “lampbackup” project to experiment with a few C++ related things).

Related Posts