mysqldump 与 7za 结合备份

@echo off
rem 先要检查 echo %date:~0,10% 的输出内容，不能含斜划线。
rem 7za.exe 下载地址 https://www.7-zip.org/a/7z2201-extra.7z
set dumpdir=D:\dump
set dbname=axshare
set axdir=C:\axShareData
set axname=axShareData
cd /d %dumpdir%
del /q /f %dumpdir%\%dbname%_%date:~0,10%.sql
mysqldump -hlocalhost -P3306 -uroot -p{paswrod} --events --routines --triggers --databases %dbname% > %dumpdir%\%dbname%_%date:~0,10%.sql
7za.exe a -t7z %dumpdir%\%dbname%_%date:~0,10%.7z %dumpdir%\%dbname%_%date:~0,10%.sql
del /q /f %dumpdir%\%dbname%_%date:~0,10%.sql
7za.exe a -t7z %dumpdir%\%axname%_%date:~0,10%.7z %axdir%
exit

rem mysqldump恢复
rem $> mysql -hlocalhost -P3306 -uroot -p{paswrod} --default-character-set=utf8
rem mysql> source dump.sql