Testlink 备份与恢复

一 初始条件:51Testing软件测试网o z2eu)b*HC

安装7zip并且将7zip.exe拷贝到Windows系统目录(如system32)，或者添加7zip的路径到系统环境变量中51Testing软件测试网!eZ"pnnCs8WZ

 51Testing软件测试网6xJpu7\8~8^%I

二 创建2个批处理脚本。backup_testlink.bat用于备份。recover_testlink.bat用于恢复testlink。

 51Testing软件测试网l iR?l

backup_testlink.bat的备份步骤51Testing软件测试网1_!r%I L2~v!Ig

step1. 备份mysql里testlink库(包括使用testlink自带的attachfiles功能上传的附件)51Testing软件测试网&sHc
y3J!s

step2. 备份使用fckedit模块上传的图片(其中图片文件夹使用7zip压缩打包，也可以设置压缩密码为test)

注:如果没有激活fckedit模块的上传图片功能，步骤2可以忽略。这里默认使用fckedit模块上传文件的路径为\www\testlink\TestLink_upload。51Testing软件测试网6zg;m:y.e:d9e

step3.记录日志

 51Testing软件测试网.wr}^BI,D;k` l#w

三 具体的2个脚本

51Testing软件测试网h0Q|[wl
H&g'g

51Testing软件测试网8H0gG|K9|G0iN1[

rem ---------------------------------------------------------------------------51Testing软件测试网$l%Aj1}+?

rem Backup testlink to localdisk51Testing软件测试网4\*z Y5AD zTb

rem Need download software 7z support,

rem $Id: bak.bat 2009-4-07 10:42:12 create by @TLbackup

rem ---------------------------------------------------------------------------51Testing软件测试网(cH!tEQ

@echo off

rem Get today's year, month, day

for /f "tokens=1-3 delims=/ " %%a in ('date /t') do (set year=%%a& set month=%%b& set day=%%c)

rem Modify the following line for your environment

set TARGET=C:\www\testlink\TestLink_upload51Testing软件测试网7G:Z(E]#\r|T(B

set TARGETNAME=TestLink_upload

set BACKUPDIR=D\tl_backup\TestLink_upload

set BACKUPFILE=%BACKUPDIR%\%year%\%TARGETNAME%_%ip%_%year%%month%%day%.zip

set LOGFILE=%TARGETNAME%_backup.log

rem set ZIPPASSWORD=test

set database = testlink;51Testing软件测试网 n1rb#t/iHOi VS

set DBuser = testlink51Testing软件测试网,S7u"l"{.x'jLI)f

set DBpwd = testlink51Testing软件测试网w'^pl-B5w`g7u

set DBbackupdir = D:\\tl_backup\\TestLink_upload\\

echo. | date | findstr "Now date" >> %LOGFILE%51Testing软件测试网x/t:w'FaXU?g

echo. | time | findstr "Now time" >> %LOGFILE%

 51Testing软件测试网l
G$A&{eFYQ

rem Compress the target directory51Testing软件测试网3m?;|3h0jX:C
P?h

7z a %BACKUPFILE% %TARGET%\*51Testing软件测试网y-H[)g:PhN*u

rem7z a -p%ZIPPASSWORD% %BACKUPFILE% %TARGET%\*

rem dump data51Testing软件测试网~-z1M%PXHVE&?/aY

mysqldump -uroot -ppasswd testlink > testlink.sql

7z a D:\\tl_backup\\TestLink_upload\\year%%month%%day%\\testlink.7z testlink.sql51Testing软件测试网?rQZl2o({
`O

del testlink.sql51Testing软件测试网tF[ i)b}.@

echo [Success] back up at %year%%month%%day% >> %LOGFILE%

echo.>> %LOGFILE%51Testing软件测试网6]1c4r j2J

goto end51Testing软件测试网Wc8i,em:p-P)r B)y ^

 51Testing软件测试网0^kY~!cu

:end51Testing软件测试网rz@/fJTa

============ backup_testlink.bat end==============51Testing软件测试网@7i pw3n5H1z

 51Testing软件测试网3M_)p
G%Nz