mysql数据备份

@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、创建定时任务

2.1、打开控制面板 > 管理工具 > 任务计划程序，创建任务：

image

2.2、填写触发器，设定执行时间：

image

2.3、添加执行脚本文件

image