MySQL Backup Script

mysql-backup-script

#!/bin/bash

BACKUP="/backups/db"

DATE=`date +"%Y-%m-%d"`
WEEKAGO=`date --date='week ago' +"%Y-%m-%d"`
DAY=`date +"%a"`
XWEEKSAGO=`date --date='5 weeks ago' +"%Y-%m-%d"`
# Day on which the weekly backup is kept. Should be the 3 char abbreviation
WEEKLY="Sun"; 

DIR="${BACKUP}/${DATE}/"
WEEKLYDIR="${BACKUP}/weekly/"
if [ ! -d $DIR ];
then
	mkdir -p $DIR
fi
if [ ! -d $WEEKLYDIR ]
then
    mkdir -p $WEEKLYDIR
fi

for DATABASE in `echo "SHOW DATABASES" | mysql -p$password -u $user | grep -v ^Database`
	do
		echo -n Backing up $DATABASE .....
		mysqldump  -p$password -u $user $DATABASE | gzip -c > ${DIR}/${DATABASE}.sql.gz 2>/dev/null
		echo Done
	done