mysql自动备份跟压缩

mysql自动备份和压缩 set today=%date:~0,4%%date:~5,2%%date:~8,2% set filename=mzo-%today% set source=d:thwlbak-sql%filename%.sql forfiles /p "d:thwlbak-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:thwlbak-sql%filename%.sql

forfiles /p "d:thwlbak-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

.syntaxhighlighter{padding-top:20px;padding-bottom:20px;}
【说明】：本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:)！