mysql数据库备份与删除脚本

备份（backup.bat）

@echo off  
set "yy=%date:~0,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%"
"D:/MySQL/mysql-8.0.16-winx64/bin/mysqldump" --opt -uroot -psocialroot social > D:/db_backup/social_%filename%.sql  
@echo on 

删除（auto delete.bat）

删除7天以前的

forfiles /p "d:\db_backup" /s /m *.sql /d -7 /c "cmd /c del @path"