Import/export test plans in 1.0.4

Ask community to help.

Moderators: Amaradana, TurboPT, TL Developers

Import/export test plans in 1.0.4

Postby jsaletan » Wed Dec 07, 2005 8:38 pm

Last night a user accidentally deleted a couple of test plans from my company\'s Testlink 1.0.4 instance. I\'ve restored the database to another system and would like to export/import just those test plans back into the production Testlink system. Is there any way to do this?

If this can\'t be done in 1.0.4, would it be possible to migrate both the production Testlink and the restored instance to a version that has this capability, and then do the export/import?

TestLink user
Posts: 1
Joined: Wed Dec 07, 2005 8:26 pm

Postby fman » Thu Dec 08, 2005 10:58 am

There is no version able of export.
What you can do is:

1. make an mysqldump of the DB wher you have the test you want
to recover.
You will get a text file plenty of SQL statements.

2. do the same with the installation where you have deleted the testcases (mysqldump).

3. create a new db copy of db where the test cases are missing, to do
some experiments on it (DBTEST)

4. do a diff between the two files

5. create a file with the missing inserts
6. apply the missing inserts to DBTEST
do some check, and I hope you have solve your problems

Please let me know the results.
Member of TestLink Community
Posts: 3088
Joined: Tue Nov 15, 2005 7:19 am

Postby Guest » Mon Dec 12, 2005 3:33 pm

Thanks for your suggestion, fman. I ended up doing just that. After the diff of the mysqldump files I had to weed out everything but the two test plans that were deleted. That ended up being more difficult than I had hoped, but I was ultimately able to recover the lost data. The diagram of the database structure from the documentation pages was invaluable.

Thanks for your help!

Return to Installation and configuration

Who is online

Users browsing this forum: Google [Bot] and 4 guests