作者：侯faulds_534 | 来源：互联网 | 2014-06-09 00:50
windows下备份mysql和网站的脚本最近使用的一个windows下的数据库和网站备份脚本:www.2cto.comsettoday%date:~0,4%-%date:~5,2%-%date:~8,2%for/f%%iin('dird:\wamp\bin\mysql\mysql5.5.20\d...
windows下备份mysql和网站的脚本
最近使用的一个windows下的
数据库和网站备份脚本:
www.2cto.com
set today=%date:~0,4%-%date:~5,2%-%date:~8,2%
for /f %%i in (&＃39;dir d:\wamp\bin\
mysql\mysql5.5.20\data /ad /b &＃39;) do d:\wamp\bin\mysql\mysql5.5.20\bin\mysqldump.exe -u root -proot %%i >d:\wamp\sql\%%i.sql
net stop wampapache
net stop wampmysqld
7z.exe a -tzip d:\wamp.backup\%today%-wamp.zip d:\wamp\ -mx0 -xr!u_mtc -xr!6027 >d:\wamp.backup\%today%-wamp.log
net start wampmysqld
net start wampapache
del /q d:\wamp\sql\*
京公网安备 11010802041100号