No announcement yet.

Merge individual threads back into forum DB

  • Filter
  • Time
  • Show
Clear All
new posts

  • 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?

  • #2
    There is no easy way to get that data back, and this is not something we provide support for.

    We only support full restores. would be able to provide more support on this subject.


    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.