MySQL Snapshots

#!/bin/sh

DIR=/opt/sql
USERNAME="userThatCanRead"
PASSWORD="Password"

rm $DIR/*.gz 2>&1 > /dev/null

DATABASES=$(echo "SHOW DATABASES" | mysql -u $USERNAME --pass=$PASSWORD | grep -v Database)

for DB in $DATABASES
do
        if ( [ "${DB}" != "information_schema" ] && [ ${DB} != "performance_schema" ] )
        then
                mysqldump -u $USERNAME --password=$PASSWORD -c --databases ${DB} > $DIR/${DB}.sql
                gzip $DIR/${DB}.sql
        fi
done

DAY=`date +%u`
if [ $DAY -eq '7' ]
then
        DX=`date +%Y%m%d`
        for DB in $DATABASES
        do
                if ( [ "${DB}" != "information_schema" ] && [ ${DB} != "performance_schema" ] )
                then
                        cp $DIR/${DB}.sql.gz $DIR/historical/${DB}-$DX.sql.gz
                fi
        done
fi