背景:
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