Simple MySQLdump script for keeping a single compressed sql backup. sloppy, assumptious.

gistfile1.txt

#!/bin/bash
USERNAME=dbuser
PASSWORD=examplepassword
DBHOST=127.0.0.1
DBNAME=singledbname
OPTIONS="--single-transaction --quick"
BACKUPDIR="/full/path/to/store/backup" # No trailing slash

# we want to make sure our new files are created only readable by owner
umask 077
/usr/bin/mysqldump -h $DBHOST -u $USERNAME -p$PASSWORD $OPTIONS $DBNAME | gzip > $BACKUPDIR/$DBNAME.inprogress.sql.gz
mv $BACKUPDIR/$DBNAME.inprogress.sql.gz $BACKUPDIR/$DBNAME.latest.sql.gz