super simple mysql backup script with mysqldump

cron_db_backup.sh

#!/bin/bash

cd /_backups

HOST="1.2.3.4"
USER="my_backup_user"
PASS="**************"

DATE_TODAY=$(date +"%Y-%m-%d")

# dump it
mysqldump -h $HOST -u $USER -p$PASS --all-databases > db_$DATE_TODAY.sql

# compress!
gzip -9 -f db_$DATE_TODAY.sql