mysqldump数据库并用7z压缩

set YYYYmmdd=%date:~0,4%%date:~5,2%%date:~8,2%
set hhmiss=%time:~0,2%%time:~3,2%%time:~6,2%
set Folder=d:\ftp_dir\db_bak_xmgr\

if not exist %Folder% md %Folder%

echo "dump start..."

D:\tools\mysql-5.7\bin\mysqldump.exe --single-transaction  -h127.0.0.1 -uhotgame -photgame82year.HL -P33123 xmgr  > D:\ftp_dir\db_bak_xmgr\xmgr-%YYYYmmdd%-%hhmiss%.sql

D:\tools\7-Zipx64\7z.exe a -tzip D:\ftp_dir\db_bak_xmgr\xmgr-%YYYYmmdd%-%hhmiss%.7z D:\ftp_dir\db_bak_xmgr\xmgr-%YYYYmmdd%-%hhmiss%.sql

del D:\ftp_dir\db_bak_xmgr\xmgr-%YYYYmmdd%-%hhmiss%.sql

echo "dump end."

备份数据库并用7z压缩