Windows服务器 自动备份 MySQL 数据

1、编写脚本

echo 取日期、时间变量值
set yy=%date:~0,4%
set mm=%date:~5,2%
set dd=%date:~8,2%
if /i %time:~0,2% lss 10 set hh=0%time:~1,1%
if /i %time:~0,2% geq 10 set hh=%time:~0,2%
set mn=%time:~3,2%
set ss=%time:~6,2%
set date=%yy%%mm%%dd%
set time=%hh%%mn%%ss%

%这里不要具体时分数据，要的话可以追加time%
set filename=%date%

%赋值等号两边不能有空格%
set mysqldumpPath="C:Program FilesMySQLMySQL Server 8.0binmysqldump.exe"
set dbName=whx_xc
set dbUser=root
set dbPwd=123456
set outpurDir=E:/MySqlBackUp/backup/

set outputFileName=%outpurDir%%dbName%_%filename%.sql

echo %outputFileName%

%mysqldumpPath% -u%dbUser% -p%dbPwd% --opt --default-character-set=utf8 -e --triggers -R --hex-blob --flush-logs -x %dbName% > %outputFileName%

2、创建计划任务

根据上面的步骤进行设置即可完成自动备份MySql数据库备份