MySQL Backup All Databases with skip

gistfile1.sh

USER="backup"
PASSWORD="****"
OUTPUTDIR="/home/dbbackup/backups"
MYSQLDUMP="/usr/bin/mysqldump"
MYSQL="/usr/bin/mysql"
SKIP=(mysql information_schema performance_schema)
# get a list of databases
databases=`$MYSQL --user=$USER --password=$PASSWORD \
 -e "SHOW DATABASES;" | tr -d "| " | grep -v Database`

# dump each database in turn
for db in $databases; do
    for skipped in "${SKIP[@]}"; do
        if [[ "$skipped" == "$db" ]]
        then
          continue 2
        fi
    done
    $MYSQLDUMP --force --opt --user=$USER --password=$PASSWORD \
    --databases $db > "$OUTPUTDIR/$db-$(date +%Y-%m-%d_%H-%M-%S).sql"
done