30-Day Rolling MySQL Database Backups

gistfile1.sh

#!/bin/bash

export d=`date +%d`
export BACKUP_DIR="/home/user/backups/$d"
export USERNAME="username"
export PASSWORD="password"
export HOST="localhost"

mkdir -p $BACKUP_DIR
for DB in db1 db2 db3
do
  echo "Backing up $DB"
  mysqldump --add-drop-table --allow-keywords --databases $DB -h $HOST -u $USERNAME -p$PASSWORD > $BACKUP_DIR/$DB.sql
  rm $BACKUP_DIR/$DB.sql.gz
  gzip $BACKUP_DIR/$DB.sql
done

Nice. Super clean, works great. This is the sort of code I like to see and put to use. Thanks.