mysql link数据同步_基于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

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