Backup MySQL databases, backup files split by date-time and database name

.my.cnf

# file: /root/.my.cnf

[client]
user = MYSQL_USER
password = MYSQL_PASSWORD
host = MYSQL_HOST

backup-db.sh

#!/usr/bin/env bash
# file: /root/scripts/backup-db.sh

DB_BACKUP_DIR_ROOT="/data/backup/mysql"
DB_BACKUP_DIR_TODAY="$DB_BACKUP_DIR_ROOT/`date +%Y-%m-%d`"
HN=`hostname | awk -F. '{print $1}'`

# Create the backup directory
mkdir -p $DB_BACKUP_DIR_TODAY

# Remove backups older than 1 day
find $DB_BACKUP_DIR_ROOT/ -maxdepth 1 -type d -mtime +1 -exec rm -rf {} \;

# Backup each db in the server, skip schema dbs though
for db in $(mysql -Bse 'show databases'|egrep -vi 'information_schema|performance_schema');
  do mysqldump --max-allowed-packet=1024M -B $db | gzip > "$DB_BACKUP_DIR_TODAY/$HN-$db-$(date +%Y-%m-%dT%H:%M:%S).sql.gz";
done

crontab

# Backup everyday at 0:0:0 and email output to [email protected]
# crontab -e
MAILTO="[email protected]"
0 0 * * * /root/scripts/backup-db.sh