1、創(chuàng)建bat任務(wù)腳本（功能：備份數(shù)據(jù)庫(kù)并刪除30天前備份文件）藤乙，并運(yùn)行測(cè)試
注：提前建好備份文件目錄（不能保護(hù)中文）；bat文件中不能包含中文
@echo off
@echo begin mysqldump
set hour=%Time:~0,2%
if "%Time:~0,1%"==" " set hour=0%Time:~1,1%
set now=%Date:~0,4%%Date:~5,2%%Date:~8,2%-%hour%%Time:~3,2%%Time:~6,2%
set host=localhost
set port=3306
set user=root
set pass=pass
set dbname=dbname
set back_path=D:\mysql-bak\gnyz
set backupfile=%back_path%\%dbname%-%now%.sql
"C:\Program Files (x86)\MySQL\MySQL Server 5.5\bin\mysqldump" -h%host% -P%port% -u%user% -p%pass% -c --add-drop-table %dbname% > %backupfile%
@echo mysqldump success
@echo begin delete 30-day files
Forfiles /p D:\mysql-bak\gnyz /s /d -30 /m *.* /c "cmd /c del /q /f @path"
@echo delete file success
2外盯、創(chuàng)建定時(shí)任務(wù)
2.1、打開(kāi)控制面板 > 管理工具 > 任務(wù)計(jì)劃程序翼雀，創(chuàng)建任務(wù)：
1.png
2.2饱苟、填寫(xiě)觸發(fā)器，設(shè)定執(zhí)行時(shí)間：
2.png
2.3狼渊、添加執(zhí)行腳本文件
3.png
