Import/export test plans in 1.0.4

[jsaletan]

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?

Thanks,
Jesse

[fman]

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.

[Guest]

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!