Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 11 Oct 2012, 20:43
Delfi_r Delfi_r is offline
 
Join Date: Jul 2011
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.
Reply With Quote
  #2  
Old 11 Oct 2012, 22:30
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
From - http://www.vbulletin.com/forum/showt...1#post1845274:
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!!!!
__________________
Former vBulletin.org Staff Member

Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #3  
Old 14 Oct 2012, 19:51
Delfi_r Delfi_r is offline
 
Join Date: Jul 2011
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..
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 20:13.

Layout Options | Width: Wide Color: