Partial Importing to recover posts from Half DB

[Alteran Ancient]

My Host's Server's DC messed up the Server A's HDD, and and the server is no longer publically viewable. I had my cPanel (and DBs) transferred to the new Server, only to find my forum's DB was half-missing, going from "A" down to "post index" and there it ends. I have all forums and posts there, but I cannot seem to recover anything after postindex. In desperation, I have re-installed cleanly, and wish to import only the forums and posts. Is there any way I can do these? I'd like to import the forums, but there is no 'user' or 'usergroup' Tables. I'd also like to import posts, but that is dependant on importing 'forum' first, which I cannot do because the forum is refusing to import. If I cannot get any of my data back, I am gonig to kill my DC. Surely there must be a way of gathering orphanned posts into Threads labelled 'Thread 1, 2 3' and so on... Does this need some other kind of script? I've been thinking that it's an idea to add one entry into each table required.

UPDATE: I decided to manually add the tables as required, and the Posts and Forums have been transferred. Aparrently.

[Jerry]

If its down to post index, you've lost your post table ?

You can create default forums and categories to import into easily enough, though if your post tables gone, that's the main one obviously.

What is the source system, another vBulletin board ?

[Alteran Ancient]

Well, basically. I had vBulletin running quite happily on my website, until my hosts old Server's HDD screwed up. All the accounts got shunted onto the new server. As soon as I got a connection, I got a Database Error. I went to investigate and FTW! My tables were there, and so was the post table, the important ones that weren't there were 'thread' and 'user'.

I've tinkered with the DB, and managed to get the system working and InpEx'd all the posts and forums. Forums came across fine (With some order issues, I'll admit), but I click on the 'Last Post' link to a forum, I get everything, except the user strip or the post content. Is it possible to get some kind of script that will move all Orphanned posts to thread X?
There's already one to delete them, so why not move them?

[Jerry]

Create a thread for the cleanup.

Lets say its threadid = 911.

Then run this SQL :



UPDATE post SET threadid=911 WHERE threadid=0;

[Alteran Ancient]

Holy.... It worked. Thanks! Now I'm having a problem witha thread with poll ID1 Anyone tries to subite their vote or view results, they receive a 'Invalid Forum Specified' error on file 'poll.php?do=pollvote&pollid=1'

[Jerry]

I'm guessing your forumid's or threadid are messed up, did you just import the forums and try and sync them with the posts ?

I'm still confused as to the actual tables you imported, created, edited etc.

[Alteran Ancient]

Well, I re-installed clean, then I imported the posts and forums. I didn't seem to have much trouble with forums. It just seems that you have a small selection of threads bunched into different forums, only to find out you have http://www.alteranlabs.co.uk/forums/showthread.php?t=398

Feel free to take a look around and see what's messed up. I'm not sure what to do now. Since not alot of this is recoverable, should I drop the DB and start again?

[Jerry]

Well, I re-installed clean, then I imported the posts and forums. I didn't seem to have much trouble with forums. It just seems that you have a small selection of threads bunched into different forums, only to find out you have http://www.alteranlabs.co.uk/forums/showthread.php?t=398

Feel free to take a look around and see what's messed up. I'm not sure what to do now. Since not alot of this is recoverable, should I drop the DB and start again?

So your source board had the user, forum, thread, and post tables, which you imported from ?

You couldn't of just imported posts and forums, with out the threads module, ImpEx would of let you.

[Alteran Ancient]

I have every table down to postindex. This means I have posts and forums, but I didn't have threads or users.

Well, for some reason, I got around it, without having to run the inport threads script. I'm just really worried about polls at the moment.

[Marco van Herwaarden]

I would strongly suggest that you try to get another complete (older?) backup from your host.

[Jerry]

I have every table down to postindex. This means I have posts and forums, but I didn't have threads or users.

Well, for some reason, I got around it, without having to run the inport threads script. I'm just really worried about polls at the moment.

With out the threads, there will be no way of syncing up the polls, as the original thread info isn't there.