extract thread from aVbulletin database

[Delfi_r]

I need to extract some thread that was deleted in a bad move from the backup database an pull in the working database.

There is a neat way to do it?

I have located the thread in the backup database.

[Lynne]

From - http://www.vbulletin.com/forum/showthread.php?326281-Recreating-a-deleted-thread-number&p=1845274&viewfull=1#post1845274:

Try this, restore the backup to a different database and using the operations tab in phpmyadmin, rename the thread and post tables to something with a number on the end (post7 and thread7) then copy those 2 tables to the live database.
Run the following queries changing 777 to the threadid of the deleted thread.
Code:

INSERT INTO thread
(SELECT *
FROM thread7
WHERE threadid = 777)

Code:

INSERT INTO post
(SELECT *
FROM post7
WHERE threadid = 777)

Before you do this - backup, backup, BACKUP! And, even better, try it on your test site first!!!!

[Delfi_r]

Thanks, I want to extract it from the test site (where I have the backup database deployed) and to copy it to the real database (another copy of the real database) and then copy to the real working database..