MySQL backup script

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

USER="root_user"
PASSWORD="root_pswt"
MYSQLDUMP="/usr/bin/mysqldump"
MYSQL="/usr/bin/mysql"
OUTPUTDIR="/path/to/sql/backup "

# 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

    ~