rem *******************************backup Start*****************************@echo offpauseset "Ymd=%date:~,4%%date:~5,2%%date:~8,2%%TIME:~0,2%%TIME:~3,2%%TIME:~6,2%"mysqldump --opt -u admin --password=test db_test > d:\backup\backSQL\db_test_%Ymd%.sqlforfiles /p "d:\backup\backSQL" /s /m *.* /d -7 /c "cmd /c del @path" pause@echo onrem *******************************backup End*****************************

定时备份脚本如上所示，再添加到任务计划里即可。