Register Members List Search Today's Posts Mark Forums Read

Thread Tools
Old 22 Apr 2011, 16:46
gamerfu's Avatar
gamerfu gamerfu is offline
Join Date: Apr 2008
Location: 台灣,&
Real name: 海富富
Question Import/Recover Posts from Backup

Does anyone know of a way to import/recover posts from a backup into the current database?

I accidentally deleted my "Recycle Bin" catagorey, and I have a back up that is 3 weeks old and was looking at how to regain those post back into my current database.

Suggestions? Solutions that have worked?

Much appericated in advanced.
Reply With Quote
Old 22 Apr 2011, 16:53
Infopro Infopro is offline
Join Date: May 2003
You could setup a test forum and try importing using the Impex script. Be sure you've tested this at least once before touching your live forums of course.
Reply With Quote
Old 22 Apr 2011, 17:44
Lynne's Avatar
Lynne Lynne is offline
Join Date: Sep 2004
Real name: Lynne
The info from this post may help -
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.

FROM thread7
WHERE threadid = 777)


FROM post7
WHERE threadid = 777)
Former 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

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:54.

Layout Options | Width: Wide Color: