[geeks] Mysql backup questions...

[Bill Bradford]

So, this is what I'm using to backup MySQL on a nightly basis (this file
is then rsynced to an offsite machine).  Any tips on optimization or
improvements?  I'm running 4.10.

#!/bin/bash
cd /usr/local/mysql/backup
DATE=`date +%m-%d-%y`
/usr/local/mysql/bin/mysqldump --password=password --create-options -qAcCe --allow-keywords --add-drop-table > /usr/local/mysql/backup/mysql-$DATE.sql
gzip --best mysql-$DATE.sql

-- 
bill bradford
houston, texas