逐日备份MySQL数据库的Windows脚本
利用Windows的日程管理器(Scheduler)每日定时执行如下内容的批处理文件：
@ECHO OFFfor /f "tokens=1-4 delims=- " %%a in ('date/t') do (set yy=%%aset mm=%%bset dd=%%cset dw=%%d)echo %dw%echo %mm%echo %dd%echo %yy%SET backupdir=F:\bak\mysqlSET mysqldir="C:\Program Files\MySQL\MySQL Server 5.1"SET dbname=testSET dbuser=rootSET dbpasswd=123456SET filename=%dbname%_%yy%-%mm%-%dd%.sql@ECHO Beginning backup of %dbname%...%mysqldir%\bin\mysqldump -u %dbuser% -p%dbpasswd% --default-character-set=gbk %dbname% > %backupdir%\%filename%@ECHO Done!