mysql自动备份

set d=%date:~0,4%%date:~5,2%%date:~8,2%
set t=%time:~0,2%%time:~3,2%%time:~6,2%
set dt=%d%%t%

"D:\\MySQL\\MySQL Server 5.1\\bin\\mysqldump.exe" --opt -uroot -p111111 verification>E:\\backup\\verification\\%dt%.sql

BCK_DIR="/home/ufo/backup/mysql-backup"
DATE=`date +%F`

mysqldump --opt -u$DB_USER -p$DB_PASS golf | gzip > $BCK_DIR/golf/db_$DATE.gz

crontab -e

0 2 * * * /home/ufo/backup/mysql-backup.sh