vb.org Archive - extract thread from aVbulletin database

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)

- - extract thread from aVbulletin database (https://vborg.vbsupport.ru/showthread.php?t=288953)

Delfi_r

10-11-2012 07:43 PM

extract thread from aVbulletin database

I need to extract some thread that was deleted in a bad move from the backup database an pull in the working database.

There is a neat way to do it?

I have located the thread in the backup database.

Lynne

10-11-2012 09:30 PM

From - http://www.vbulletin.com/forum/showt...1#post1845274:

Quote:

Originally Posted by Lats

Try this, restore the backup to a different database and using the operations tab in phpmyadmin, rename the thread and post tables to something with a number on the end (post7 and thread7) then copy those 2 tables to the live database.
Run the following queries changing 777 to the threadid of the deleted thread.
Code:

INSERT INTO thread
(SELECT *
FROM thread7
WHERE threadid = 777)

Code:

INSERT INTO post
(SELECT *
FROM post7
WHERE threadid = 777)

Before you do this - backup, backup, BACKUP! And, even better, try it on your test site first!!!!

Delfi_r

10-14-2012 06:51 PM

Thanks, I want to extract it from the test site (where I have the backup database deployed) and to copy it to the real database (another copy of the real database) and then copy to the real working database..

All times are GMT. The time now is 10:10 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01027 seconds Memory Usage 1,712KB 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)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)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
Messages: