怎么自动备份mysql数据库备份_3步教你一键自动备份mysql数据库的方法

@echo off

color 0D

MODE con: COLS=71 LINES=25

title mysql数据库自动备份脚本(任务计划)--脚本作者：https://www.***.com

set sou_dir="D:\mysql\Mysql\data"

set obj_dir=F:\beifen\%date:~0,10%

net stop mysql

md %obj_dir%

xcopy /e /y %sou_dir% %obj_dir%

net start mysql

@echo off&setlocal enabledelayedexpansion

call:D,30

echo. 30天前日期为：%D%

echo. 删除30天以前备份......

if exist F:\beifen\%D% rd /s /q F:\beifen\%D%

echo 自动备份完成，程序将自动退出......

ping -n 2 127.0.0>nul

exit

:D

for /f "tokens=1-3 delims=-:/ " %%a in ("%date%") do (

set Y=%%a&set M=%%b&set D=%%c

if "!M:~0,1!"=="0" set M=!M:~1!

if "!D:~0,1!"=="0" set D=!D:~1!

)

set/a D-=%1

if %D% gtr 0 goto:Y

:M

set/a M-=1

if !M!==0 set/a Y-=1,M=12

set/a "T=^!(M-2)","R=(^!(Y%%4)&^!^!(Y%%100))|^!(Y%%400)","C=^!(M-4)|^!(M-6)|^!(M-9)|^!(M-11)","D=T*(28+R)+C*30+(^!T&^!C)

*31+D"

if %D% leq 0 goto:M

:Y

set M=0%M%&set D=0%D%&set D=%Y%-!M:~-2!-!D:~-2!