自动备份
@echo off
@title 数据备份
set "yMd=%date:~,4%%date:~5,2%%date:~8,2%"
echo 日期:%yMd%
set "hms1=%time:~0,2%%time:~3,2%%time:~6,2%"
echo 时间:%hms1%
set "t=%time: =0%"
echo 时间:%t%
set "hms=%t:~0,2%%t:~3,2%%t:~6,2%"
echo 时间:%hms%
set "dd=F:mysql_bak"
echo 文件夹:%dd%
echo 判断文件夹是否存在,不存在创建
if not exist "%dd%" md "%dd%"
echo 执行备份:%dd%/mysql_backup_%yMd%-%hms%.sql
"C:/Program Files/MySQL/MySQL Server 5.7/bin/mysqldump.exe" -hlocalhost -p3306 -uroot -密码 --skip-lock-tables 表名 > %dd%/mysql_backup_%yMd%-%hms%.sql
TIMEOUT /T 10
@echo on
删除备份
rem 删除D:\temp目录下7天前的文件
Forfiles /p F:\mysql_bak\mysql_bak /s /d -14 /m *.* /c "cmd /c del /q /f @path"
计划任务
![在这里插入图片描述](https://img-blog.csdnimg.cn/df31028e3bb94c039b3119cfc4168987.png)