Home >Database >Mysql Tutorial >mysql自动备份跟压缩
mysql自动备份跟压缩
- WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
- 2016-06-07 16:25:301331browse
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
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：mysql抉择联合索引还是单索引？索引列应该使用哪一个最有效？深Next article：mysql学习之5：sql语句学习3