Hi Darrell,
I manage over 20 vBulletin sites... Are you sure it's not just soft
deleted? I mean, you have to _really_ want something hard deleted... 3
steps to get it permanently deleted. FWIW, I would make the forum so
moderators can only soft delete...
OTH, If you're REALLY desperate, I would grab the mysql backup you speak
of, do another mysql dump, temporarily close the forum, compare the
differences and make the appropriate edits to the mysql file and then
import the whole mess back in.
I do like Chris's hourly labor point...
;)
Darrell D. Mobley wrote:
>> -----Original Message-----
>> From: Chris Gebhardt - VIRTBIZ Internet [mailto:cobaltfacts (at mark) virtbiz.com]
>> Sent: Tuesday, September 15, 2009 5:11 PM
>> To: coba-e (at mark) bluequartz.org
>> Subject: [coba-e:16033] Re: Restoring a record from a RaqBackup MySQL dump
>>
>> 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...
>
> Yeah, I misspoke, as I knew it was a cumulative of individual posts tied
> into a thread. Since it was deleted, the ids of the posts are no longer
> there, so adding them back individually by hand would work. I just don't
> know if I want to tackle such a large project.
>
>