基于MySQL数据迁移的多testlink同步解决方案

背景：

BJ研发内网使用Testlink1管理测试计划，测试案例

TJ研发内网使用testlink2管理测试计划，测试案例

两个网段均为独立局域网，只能通过一台FTP, TJ->BJ，

现在需要testlink1与testlink2同步

 

解决方案：

使用mysql的数据库迁移功能

TJ：

CreateDump.bat:

mysqldump testlink -uroot >dump.sql

 

Local2FTP.bat

echo open 10.0.0.1 999>ftp.txt
echo user>>ftp.txt
echo password>>ftp.txt
echo binary >>ftp.txt
echo cd %Dir%>>ftp.txt
echo mput *.sql>>ftp.txt
echo bye>>ftp.txt

ftp -s:ftp.txt
del ftp.txt

 

Upload.bat

echo.
echo creating dump file for testlink database...
echo ----------------------------------------
call CreateDump.bat %dumpName%
echo Created %dumpName%

echo.
echo Uploading dump to ftp server...
echo ----------------------------------------
call Load2FTP.bat %dumpName%
echo Upload %dumpName% to ftp

BJ

FTP2Local.bat

echo open 10.0.0.1 999>ftp.txt
echo user>>ftp.txt
echo password>>ftp.txt
echo binary >>ftp.txt
echo cd %Dir%>>ftp.txt
echo mget *.sql>>ftp.txt
echo bye>>ftp.txt

ftp -s:ftp.txt
del ftp.txt

RestoreDB.bat

mysql testlink -uroot <%dumpName%

 

Syncup.bat

echo.
echo Getting dump file %dumpName% from ftp...
echo ----------------------------------------
call FTP2Local.bat %dumpName%
echo Got %dumpName%

echo.
echo Restore testlink database using %dumpName%...
echo ----------------------------------------
call Restore.bat %dumpName%
echo Restore %dumpName% for testlink