The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Merge individual threads back into forum DB
Someone on our boards managed to take control of a moderator account and hard delete several very large threads.
I have a backup of the database that is about 2 weeks old. I would like to grab the threads out of that copy and merge them back into the current database. I don't just want to restore the entire forum to 2 weeks ago, but I'm ok just having 2 week old versions of those particular threads merged into the current up to date DB. Am I right in my assumpion that the process for doing this is the following 1. "select * from post where threadid = myID" 2. Export the results as insert statements 3. Execute the inserts on the current DB Is there anything else to it? Do I need anything besides the post table? Will this also bring back user's post counts, etc? --------------- Added [DATE]1332906822[/DATE] at [TIME]1332906822[/TIME] --------------- I went ahead and restored all the rows in the post table with one of the deleted thread IDs. The import went fine and the rows are there but the post does not show up in the forum. Anyone know what other tables I need to copy the data from? --------------- Added [DATE]1332907075[/DATE] at [TIME]1332907075[/TIME] --------------- EDIT2: Copying the row from the 'thread' table made it show up. Now to figure out how to restore user posts/credits. |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|