Windows系统mysql数据库一种备份方式BAT文件执行

@ECHO OFF

C:

:: 1备份目录
SET DR=D:\DB_Bak

:: 日期
set CurTime=%time%
set hh=%CurTime:~0,2%
set hh
if /i %hh% LSS 10 (
set hh=0%CurTime:~1,1%
)
set hh
SET TT=%date:_2,2%%date:5,2%%date:_{8,2%-%hh%%time:}3,2%%time:~6,2%
echo %TT%

SET TM=%date:_0,4%%date:5,2%%date:~8,2%

:: WINRAR程序路径
SET RARPATH=“C:\Program Files (x86)\WinRAR\WinRAR.exe”

:: 2MYSQL数据库路径
SET MYSQL=D:\mysql\58food_mysql-5.7.17-winx64\data

:: 备份目录是否存在,不存在则新建
IF NOT EXIST %DR% MD %DR%

:: 备份MYSQL数据库
ECHO -------------------------------备份MYSQL数据库--------------------------------
net stop MySQL57
ping 127.0.0.1 -n 15
%RARPATH% a -r -y -ep1 -ibck -os -x%MYSQL%\ib_logfile* -x%MYSQL%\test* -x%MYSQL%\ibdata* -x%MYSQL%*.err -x%MYSQL%*.pid %DR%[%TT%]sqldb.rar %MYSQL%
net start MySQL57
ECHO -------------------------------备份MYSQL数据库结束----------------------------
echo %DR%[%TT%]sqldb.rar> %DR%\DB_bak.txt