Dumb DB backup script.

gistfile1.sh

#!/bin/bash

# Store backup in this directory:
dir="/home/xxx/database_backups/"

# Backups will be stored in the pattern $filename-date-time.sql.gz
filename="dbbackup.myblog.com"

# Database to backup
db=blog

#################################

# Bash script to dump the blog database, zip it, and move it to /home/xxx/database_backups.
date=`date +%Y%m%d`
time=`date +%H%M%S`
filename=$filename-$date-$time.sql

mysqldump -C $db > /tmp/$filename
gzip /tmp/$filename
mv /tmp/$filename.gz $dir

# symlink current.sql.gz
rm -f $dir/current.sql.gz
ln -s $dir/$filename.gz $dir/current.sql.gz