#!/bin/bash
# /home/username/bin/backup_db.sh
# MySQL Backup

DATE=`date "+%y%m%d"`

BACKUP_DEST="/home/username/site/production/current/db"
DB="database_name"
DB_USER="db_user"
DB_USER_PW="db_password"
DB_BACK=$BACKUP_DEST/$DATE-db.sql.gz

/usr/bin/mysqldump --password=$DB_USER_PW -Ke -u $DB_USER $DB | gzip > $DB_BACK
#### END