gistfile1.txt

#!/bin/bash
DB_USER="root"
DB_PASS="…"
BACKUP_DIR="/srv/backups/mysql"
TODAY=$( date +%d)

DATABASES=$(mysql -u ${DB_USER} -p"${DB_PASS}" -N -B -e 'SHOW DATABASES')

for DATABASE in $DATABASES
do
        BACKUP_FILE="${BACKUP_DIR}/${TODAY}-${DATABASE}.gz"
        mysqldump -u ${DB_USER} -p"${DB_PASS}" --skip-extended-insert --skip-quick "$DATABASE"|gzip -9 > "${BACKUP_FILE}"
done