#!/bin/bash
# List all databases, backup them seperately gzipped

USER="XXX"
PASSWORD="XXX"
HOST="XXX"
now="$(date +'%d-%m-%Y')"
DATABASES=`mysql -u ${USER} -p${PASSWORD} -h ${HOST} -e "SHOW DATABASES;" | tr -d "| " | grep -v Database`

for db in ${DATABASES}; do
    if [[ ${db} != "information_schema" ]] && [[ ${db} != "performance_schema" ]] && [[ ${db} != "mysql" ]] && [[ ${db} != _* ]] ; then
        echo "Dumping database: "${db}
        mysqldump -u ${USER} -p${PASSWORD} -h dbint059803 ${db} | gzip -v > "backups/db/${now}_${db}.sql.gz"
    fi
done