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