#!/bin/bash

USER="root"
PASSWORD=""
OUTPUT="./databases"

rm ./databases/*.gz > /dev/null 2>&1
rm ./databases/*.sql > /dev/null 2>&1


databases=`mysql -u $USER -e "SHOW DATABASES;" | tr -d "| " | grep -v Database`

for db in $databases; do
	db="$(echo $db)"
    if [[ "$db" != "information_schema" ]] && [[ "$db" != "performance_schema" ]] && [[ "$db" != "mysql" ]] && [[ "$db" != _* ]] ; then
        echo " Dumping $db "
        mysqldump -u $USER  --databases $db > $OUTPUT/`date +%Y%m%d`.$db.sql
        #gzip $OUTPUT/`date +%Y%m%d`.$db.sql
    fi
done