MySQL Backup Script (Bash)

gistfile1.sh

#!/bin/sh
#backup all mysql databases
# list MySQL databases and dump each
DIR=/backup/mysql/
DATESTAMP=$(date +%Y%m%d)
DB_USER=mysqlbackup
DB_PASS=kate@racers#45

# remove old backups
find ${DIR} -type f -mtime +5 -exec rm -rf {} \;

DB_LIST=`mysql -u $DB_USER -p"$DB_PASS" -e'show databases;'`
DB_LIST=${DB_LIST##Database}
for DB in $DB_LIST;
do
  FILENAME=${DIR}${DB}-${DATESTAMP}.sql.gz
  mysqldump -u $DB_USER -p"$DB_PASS" --opt --flush-logs $DB | gzip > $FILENAME
done

mysqlcheck -u $DB_USER -p"$DB_PASS" --all-databases > /root/mysql_backups/check_errors-${DATESTAMP}.log