mysqldump命令

@echo off  
set "dateYmds=%date:~,4%%date:~5,2%%date:~8,2%"
echo "%dateYmd%"
"C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqldump.exe" -uuser -ppassword -h127.0.0.1 databases --extended-insert=false  > E:/sql_%dateYmd%.sql
@echo on  

windows下创建任务

windows下mysqldump定时备份