mysql自动备份和压缩 set today=%date:~0,4%%date:~5,2%%date:~8,2% set filename=mzo-%today% set source=d:\thwl\bak-sql\%filename%.sql forfiles /p d:\thwl\bak-sql? /m *.7z /d -15 /c cmd /c del @path mysqldump -uroot -pszk^^^^* -r mzo %sourc
mysql自动备份和压缩
set today=%date:~0,4%%date:~5,2%%date:~8,2%
set filename=mzo-%today%
set source=d:\thwl\bak-sql\%filename%.sql
forfiles /p d:\thwl\bak-sql? /m *.7z /d -15 /c cmd /c del @path
mysqldump -uroot -pszk^^^&^* -r mzo > %source%
haozipc a -t7z %filename%.7z %filename%.sql
del %filename%.sql