作者:熊字饼爱优乐美 | 来源:互联网 | 2018-06-10 15:11
mysql自动备份和压缩setToday%date:~0,4%%date:~5,2%%date:~8,2%setfilenamemzo-%Today%setsourceD:thwlbak-sql%filename%.sqlforfilespD:thwlbak-sql?m*.7zd-15ccmdcdel@pathmysqldump-uroot-pszk^^^^*-RMZO%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 %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