forfiles/p "D:\DBBackup"/M "*.sql"/d-08/c "cmd/c del @path"
forfiles/p "D:\DBBackup\backuplog"/M "*.rar"/d-03/c "cmd/c del @path"
@echo off
Set Errorlevel=0
Set Dbuser=backup
Set DBPASSWORD=PASSWD
Set ip=192.168.1.1
Set port=3306
mysql-u%dbuser%-p%dbpassword%-h%ip%-p%port% < D:\DBBackup\scripts\dbname.sql > D:/dbbackup/logdbname.txt
D:
CD D:/dbbackup
More +1 logdbname.txt > logdbname.tmp
Del Logdbname.txt
ren logdbname.tmp logdbname.txt
for/f "Tokens=1 delims="%%i in (d:/dbbackup/logdbname.txt) do mysqldump-u%dbuser%-p%dbpassword%-h%IP%-P%port%%%i > D:/dbbackup/%%i_%date:~0,4%%date:~5,2%%date:~8,2%.sql
for/f "Tokens=1 delims="%%i in (d:/dbbackup/logdbname.txt) do start/wait c \ "program Files" \winrar\winrar.exe-y u-a GYYYYMMDD-EP1 D:\DBBackup\backuplog\%%i_.rar D:\dbbackup\%%i_%date:~0,4%%date:~5,2%%date:~8,2%*.sql
Bat script, back up the database and compress