windows定时备份mysql保留七天_windows下对mysql进行定时备份

参考：https://www.cnblogs.com/AlienXu/p/9436829.html

https://www.cnblogs.com/xiaostudy/p/10079502.html

@echo off

set yy=%date:~,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%

set filename=%date%_%time%

"E:/Mysql/mysql-5.7.26-winx64/bin/mysqldump.exe" -u账号 -p密码 --opt --default-character-set=utf8mb4 --routines 数据库名字 > E:/数据库名字_%filename%.sql

@echo on

#pause