1.新建txt文件,输入以下
@echo off
set "yMd=%date:~,4%%date:~5,2%%date:~8,2%"
set "hms=%time:~,2%%time:~3,2%%time:~6,2%"
"J:/Program Files/MySQL/MySQL Server 5.5/bin/mysqldump.exe" -uroot -p123 gra>mysql_backup_%yMd%-%hms%.sql
@echo on
2.根据window10自带的任务计划,建立定时计划