Steven Engelhardt

Courtesy of Dave, here’s a script I put into crontab to perform nightly full backups of my WordPress MySQL database:

#!/bin/sh

DATE=`date +%Y-%m-%d`
BACKUPDIR=$HOME/.mysql-backup

USERNAME=XXXXX # TODO
PASSWORD=XXXXX # TODO
DATABASE=XXXXX # TODO

if [ ! -d $BACKUPDIR/$DATABASE ]; then
  mkdir $BACKUPDIR/$DATABASE
fi

mysqldump --user=$USERNAME --password=$PASSWORD $DATABASE > $BACKUPDIR/$DATABASE/$DATE.dump
bzip2 -9 $BACKUPDIR/$DATABASE/$DATE.dump