mysql-backup/mysql-backup.sh

#!/bin/bash

USER="backup"
PASSWORD="OGaFNoafEgCPUnutCQB7"
OUTPUT="/backup/$(hostname -s)"

###################################

find ${OUTPUT}/*.sql -mtime +30 -exec rm {} \;

ExcludeDatabases="Database|information_schema|performance_schema|mysql"
databases=$(mysql -u $USER -p$PASSWORD -e "SHOW DATABASES;" | tr -d "| " | egrep -v $ExcludeDatabases)

for db in $databases; do
    echo "Dumping database: $db"
    mysqldump -u $USER -p$PASSWORD --databases $db > ${OUTPUT}/$(date +%Y%m%d).$db.sql
    # gzip $OUTPUT/`date +%Y%m%d`.$db.sql
done