定时备份mysql

@echo off
set filename=%date:~0,4%%date:~5,2%%date:~8,2%%time:~0,2%%time:~3,2%%time:~6,2%
mysqldump --single-transaction --flush-logs --master-data=2 -uroot -proot www >d:\db\%filename%.sql