vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   Merge individual threads back into forum DB (https://vborg.vbsupport.ru/showthread.php?t=280743)

Vcize 03-27-2012 05:02 PM

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.


All times are GMT. The time now is 01:54 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04143 seconds
  • Memory Usage 1,705KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (1)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete