#!/bin/bash OUTPUT="/var/lib/backupdb" cd $OUTPUT databases=`mysql -e "SHOW DATABASES;" | tr -d "| " | grep -v Database` for db in $databases; do if [[ "$db" != "information_schema" ]] && [[ "$db" != "performance_schema" ]] && [[ "$db" != _* ]]; then YESTERDAY=$OUTPUT/`date --date='yesterday' +%Y%m%d`.$db.sql.gz if [[ -f ${YESTERDAY} ]]; then rm ${YESTERDAY}; fi DUMP=$OUTPUT/`date +%Y%m%d`.$db.sql echo "Dumping database: $db" mysqldump --databases $db > $DUMP gzip $DUMP fi done