windows备份mysql数据库_windows备份mysql数据库

1、编写执行文件mysql_backup.bat

rem auther:ELSON ZENG

rem date:20191104

rem mysql backup!

@echo off

set mysql_dump="C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqldump.exe"

set Ymd="%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%%TIME:~0,2%%TIME:~3,2%"

set backup_path="D:\mysql_backup"

rem 删除过期30天前的数据备份

forfiles /p %backup_path%\data /m backup_*.sql -d -30 /c "cmd /c del /f @path"

rem 开始备份

%mysql_dump% -uroot -p123456 -P 3306 --all-databases --routines > "%backup_path%\data\backup_%Ymd%.sql"

set var=%errorlevel%

@echo on

if %var% EQU 0 (

echo "%DATE:~0,4%-%DATE:~5,2%%DATE:~8,2%-%TIME:~0,2%%TIME:~3,2% backup success!" >> %backup_path%\logs\mysql_backup.log

) else (

echo "%DATE:~0,4%-%DATE:~5,2%%DATE:~8,2%-%TIME:~0,2%%TIME:~3,2% backup fail!" >> %backup_path%\logs\mysql_backup.log

)

2. 添加计划任务

我的电脑(右键)-- 管理 -- 任务计划程序 -- 任务计划程序库 -- 创建任务