MySQL定时备份语句 全量备份+zip压缩+自定义天数删除

直接撸代码 

@echo off
:start
::echo 1 设置MySql数据库的连接信息

set host=127.0.0.1
set port=3306
set user=root
set pass=qwe123
set expires_day=0
set dbname=testdb

::echo 2 设置Mysql安装地址的bin路径

set bin_path="D:\Program\mysql-5.7.37-winx64\bin\"

::echo 3 设置备份的存储路径，例如c:\DBBAK\mysql\

set save_path="c:\DBBAK\mysql\"

::echo 4 获取当天的日期格式，例如：2022122031300

set hour=%time:~0,2%
if "%time:~0,1%"==" " set hour=0%time:~1,1%
 
set backup_date=%Date:~0,4%%Date:~5,2%%Date:~8,2%%hour%%Time:~3,2%%Time:~6,2%

::echo 5 设置备份sql文件名

set sql_path=%save_path:~1,-1%%dbname%_%backup_date%.sql
 
::echo 6 设置zip压缩软件的安装路径/压缩密码/备份压缩路径/删除过期的压缩文件的匹配字符串

set zip_path="C:\Program Files\7-Zip\7z.exe"
set zip_pass=123
set zip_query_path="%save_path:~1,-2%"
set zip_sql_path=%save_path:~1,-1%%dbname%_%backup_date%.zip
set zip_del=%dbname%_*.