wangsisi 发表于 2011-7-1 10:33:49

利用批处理备份Mediawiki系统

WIKI系统没有自带的备份工具,手动备份起来比较麻烦,写了个批处理来备份,包括数据库和wiki系统,思路是备份数据库然后将wiki文件夹压缩完全备份。
批处理代码如下:
@echo off
echo 如果当天已有备份,继续操作将删除原有备份!
echo. & pause

del %date:~0,4%-%date:~5,2%-%date:~8,2%\*.* /q
rd %date:~0,4%-%date:~5,2%-%date:~8,2%
echo 成功清除已有备份文件!
echo 删除当天已备份文件夹%date:~0,4%-%date:~5,2%-%date:~8,2%

echo.
del foldlist.txt
dir /a:d/o:-n/b >> foldlist.txt
for /F "skip=5"%%iIN (foldlist.txt) do del %%i /q & rd %%i & echo 删除备份文件夹%%i>>log.txt
echo 成功清除5次之前的备份文件!

echo .
echo 按日期创建备份文件夹:%date:~0,4%-%date:~5,2%-%date:~8,2%成功!
mkdir   %date:~0,4%-%date:~5,2%-%date:~8,2%

echo .
echo 开始备份数据库qianzhiwikidb_%date:~0,4%%date:~5,2%%date:~8,2%.sql到%date:~0,4%-%date:~5,2%-%date:~8,2%中,请稍候......
rem 以下内容需要根据实际情况修改:mysqldump文件的实际位置、MySQL的用户名和密码、需要备份的数据库名
C:\wamp\mysql\bin\mysqldump --user=root --password=123 qianzhiwikidb>%date:~0,4%-%date:~5,2%-%date:~8,2%\qianzhiwikidb_%date:~0,4%%date:~5,2%%date:~8,2%.sql
rem 以上内容需要根据实际情况修改:mysqldump文件的实际位置、MySQL的用户名和密码、需要备份的数据库名

echo .
echo 成功备份数据库,备份时间:%date:~0,4%-%date:~5,2%-%date:~8,2% >> log.txt
echo 开始压缩wiki系统并备份qianzhiwiki_%date:~0,4%%date:~5,2%%date:~8,2%.rar到%date:~0,4%-%date:~5,2%-%date:~8,2%中,请稍候......
rem copy "C:\Program Files\WinRAR\WinRAR.exe" WinRAR.exe
rem 将WinRAR.exe拷贝到当前目录,路径中有空格需加双引号

winrar A -o+ -ibck -ep1 %date:~0,4%-%date:~5,2%-%date:~8,2%\qianzhiwikidb_%date:~0,4%%date:~5,2%%date:~8,2%.rar %date:~0,4%-%date:~5,2%-%date:~8,2%\qianzhiwikidb_%date:~0,4%%date:~5,2%%date:~8,2%.sql
del %date:~0,4%-%date:~5,2%-%date:~8,2%\qianzhiwikidb_%date:~0,4%%date:~5,2%%date:~8,2%.sql
rem 压缩并删除源文件

winrar A -o+ -ibck -ep1 %date:~0,4%-%date:~5,2%-%date:~8,2%\qianzhiwiki_%date:~0,4%%date:~5,2%%date:~8,2%.rar C:\wamp\www\QianzhiWiki
rem 参数-ibck是后台运行的意思,-o+覆盖,-ep1不保存文件夹前面路径

echo .
echo 成功备份wiki系统!
echo 成功备份wiki系统,备份时间:%date:~0,4%-%date:~5,2%-%date:~8,2% >> log.txt

页: [1]
查看完整版本: 利用批处理备份Mediawiki系统

美国HostEase虚拟主机一年198元