mysql 自动备份数据库 批处理文件

@ECHO OFF
:begin 
md D:\work\dbBackup\%date:~,4%%date:~5,2%%date:~8,2%;
mysqldump -uroot -p nlticket3 --default-character-set=utf8 --opt --extended-insert=false --hex-blob -R -x > D:\work\dbBackup\%date:~,4%%date:~5,2%%date:~8,2%\nlticket.sql
@echo nlticket %date:~,4%%date:~5,2%%date:~8,2%日数据库配置完成
pause
:end

-u 账号 -p密码  md D:\work\dbBackup\%date:~,4%%date:~5,2%%date:~8,2%; 创建以当前日期命名的文件夹 如20120718 然后将备份好的.sql文件放进进去