mysqldump 与 7za 结合备份

@echo off
rem 先要检查 echo %date:~0,10% 的输出内容，不能含斜划线。
rem 7za.exe 7za.dll 7zxa.dll 的 %path% 中已存在。 

:publicVariable
set backupDir=C:\backups
set dumpDir=C:\Downloads

:bakMySQL-abc
set dbName=abc
set dbUser=abc_user
set dbPassword=3BwcmyCXagT2
del /q /f %backupDir%\db_%dbName%_*.7z
mysqldump -hlocalhost -P3306 -u%dbUser% -p%dbPassword% --events --routines --triggers --databases %dbName% > %dumpDir%\db_%dbName%_%date:~0,10%.sql
7za.exe a -t7z %backupDir%\db_%dbName%_%date:~0,10%.7z %dumpDir%\db_%dbName%_%date:~0,10%.sql
del /q /f %dumpDir%\db_%dbName%_%date:~0,10%.sql

:bakFiles-abc
set sourceName=abc
set sourceDir=C:\abc
del /q /f %backupDir%\file_%sourceName%_*.7z
7za.exe a -t7z %backupDir%\file_%sourceName%_%date:~0,10%.7z %sourceDir%

exit

 auotBackupFiles.7z