Import/Recover Posts from Backup

[gamerfu]

Does anyone know of a way to import/recover posts from a backup into the current database?

I accidentally deleted my "Recycle Bin" catagorey, and I have a back up that is 3 weeks old and was looking at how to regain those post back into my current database.

Suggestions? Solutions that have worked?

Much appericated in advanced.

[Infopro]

You could setup a test forum and try importing using the Impex script. Be sure you've tested this at least once before touching your live forums of course.

[Lynne]

The info from this post may help - 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)