PDA

View Full Version : Restore threads using 'post' table


kaotic
05-04-2003, 12:45 AM
I'm stuck in an odd situation. I had 2 backups of the forums. Somehow, my earliest backup wasn't completed. I was able to update all of the MySQL tables up to the search index table, meaning I was missing important tables like 'user' and 'thread.' I was, however, able to restore an early backup of the 'post' table. For now, I'm using the old table backups. Now I need a hack or modification of some sort that will rebuild threads table using information from the 'post' table. I believe there is something floating around that will restore the 'user' table using information from the 'post' table, but I wasn't able to find it. A link to that would also be very helpful. Thanks.

Note: I looked for something like this in the counters page within the admin cp, but it only deletes orphan posts instead of using them to recreate the threads.

filburt1
05-04-2003, 12:56 AM
It's possible except for one critical detail (among others): you don't know the original forumid of the deleted threads to be able to recreate them.

Dr. Bantham
07-23-2011, 01:05 PM
I have need for this. Somehow about 100 of my threads were deleted/corrupted, but the original posts remain intact. How can I re-create the original thread table entries using the post table?