delbackup.bat

来自「mysql备份程序,很好很强大,欢迎使用」· Batch 代码 · 共 33 行

@echo off

::设置删除的天数，下面设置删除7天前的文件
set delDay=7

::下面将执行删除
setlocal EnableDelayedExpansion

>tmptmp.vbs echo wscript.echo dateadd("d",-%delDay%,date)
for /f "tokens=1,2,3* delims=-" %%i in ('cscript /nologo tmptmp.vbs') do (
set "y=%%i"&set "m=%%j"&set "d=%%k"
)

if %m% LSS 10 set "m=0%m%"
if %d% LSS 10 set "d=0%d%"
set "rq=%y%-%m%-%d%"

echo.&echo 注意:即将删除 %rq% 以前建立的文件

::判断文件
for /f "delims=" %%a in ('dir/b/a-d D:\MysqlBackUp\*.*') do (
set "a=0"
for /f "skip=4 delims=" %%b in ('dir/tc "D:\MysqlBackUp\%%a"') do (
set /a "a+=1"
if !a! equ 1 (
set "var=%%b"
for /f "tokens=1 delims= " %%c in ("!var!") do set "str=%%c"
if !str! lss !rq! del /q "D:\MysqlBackUp\%%a"
)))

del/q tmptmp.vbs
)
exit