MySql for win 自动备份批处理

@echo off
set dbname=test
set datestr=%date:~0,4%%date:~5,2%%date:~8,2%
set file=%dbname%_%datestr%.sql
echo backup database: %dbname% to %file% ...
"D:\Program Files\MySQL\MySQL Server 5.0\bin\mysqldump.exe" -u root -p %dbname% > %file%
echo OK