Darrell D. Mobley wrote:
> I have a website where a moderator mistakenly deleted a vBulletin
> thread. I have the MySQL database dump file from RaqBackup, which runs
> every night. I want to extract just that one record and restore it on
> the server.
>
> What is the best way to do this?
Hi Darrell,
I think this is going to be a fair amount of work - maybe more trouble
than it's worth. This is largely because IIRC (I haven't toyed with
vBulletin in a long time) the individual post would have it's hooks in
several records spread across several tables. ie: the text of each post
would have its own record in one table, which is linked to the author's
post count in a different table, etc. Somebody with better / more
recent vBulletin work may be better to ask about this, or even on the
vBulletin lists/forums/thingies.
But the bottom line is I do not believe there is any single record, or
even table, that would have to be restored.
And if your forum has any bit of traffic on it, restoring to last
night's backup is probably not a good idea.
Now, with some fancy diff work you could merge last night's backup in
with changes made since then. But that's a little more involved than
I'd be able to guide you through here...
--
Chris Gebhardt
VIRTBIZ Internet Services
Access, Web Hosting, Colocation, Dedicated
www.virtbiz.com | toll-free (866) 4 VIRTBIZ