You will have to query the database (the backup) and see which records are related to that thread and import them in the live site.

It will be a quite tricky since you will have to find all the records (replies) related to this thread. The way to do it is as follows:

Restore the MySQL table w3t_Posts in a test/dummy database on your computer or somewhere else.

Use the Search function of phpMyAdmin to locate the record of the thread. Your search criteria might be the B_Board field which holds the Board that the thread was in and then you can also filter by B_Subject. You must find the thread that has B_Parent = 0 since this is your starting thread. Write down its B_Number because you will use that. Then a query like:

Code
SELECT * FROM w3t_Posts WHERE B_Number = 'Your number here' OR B_Main = 'Your Number here';

This will give you all the records of that thread. Now in order to get them all in your live database - the way I would go about it - is to delete all the records from the test w3t_Posts table and then export the remaining ones and import them in the live table.

Code
DELETE FROM w3t_Posts WHERE B_Number <> 'Your number here' OR B_Main <> 'Your Number here';

Check the record count. If the records remaining in the w3t_Posts table is the same as the ones that the SELECT query returned then you are in a good path.

Next, backup your live database's w3t_Posts table and keep it handy.

Export the w3t_Posts table from the test database and using phpMyAdmin start inserting the records in the live database. If you insert the first record (the one that has B_Parent = 0) the thread should appear (since that one is the first record). Then one by one you can start importing them and see the results.

If anything goes wrong you can restore the w3t_Posts table from the backup you got earlier (live server)

I hope this helps

Nikos

Web Desing/Programming: http://niden.net