#!/bin/bash

USER="root"
PASSWORD="Agr5tvD1fzGWwvXrdtawRAB"
OUTPUTDIR="/backup/mysql"

databases=`mysql -u $USER -p$PASSWORD -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 --single-transaction -u $USER -p$PASSWORD --databases $db > $OUTPUTDIR/`date +%Y%m%d`.$db.sql
        gzip $OUTPUTDIR/`date +%Y%m%d`.$db.sql
    fi
done

/usr/bin/find /backup/mysql/ -mtime +30 -exec rm -f {} \;