backup-sql

#! /bin/sh
export DAY
declare DAY=`date|cut -c 1-3`

USER="root"
PASSWORD="password"
MYSQLDUMP="/usr/bin/mysqldump"
MYSQL="/usr/bin/mysql"
OUTPUTDIR="/home/sdstern/Backup/sugaree/sql"

# get a list of databases
databases=`$MYSQL --user=$USER --password=$PASSWORD \
 -e "SHOW DATABASES;" | tr -d "| " | grep -v Database`


for db in $databases; do
    if [[ "$db" != "information_schema" && "$db" != "performance_schema" ]];
      then
         $MYSQLDUMP --events --user=$USER --password=$PASSWORD --databases $db |gzip > "$OUTPUTDIR/$db-$DAY.sql.gz";

    fi
done