Index: [Article Count Order] [Thread]

Date:  Tue, 15 Sep 2009 18:44:21 -0400
From:  "Darrell D. Mobley" <dmobley (at mark) uhostme.com>
Subject:  [coba-e:16035] Re: Restoring a record from a RaqBackup MySQL dump
To:  <coba-e (at mark) bluequartz.org>
Message-Id:  <C73350DFFC944C75943FD12B7066F143@HP9925NR>
In-Reply-To:  <4AB002D0.4010206 (at mark) virtbiz.com>
References:  <3B35D6D4B1B14E46BF31CB4130CF345A (at mark) HP9925NR> <4AB002D0.4010206 (at mark) virtbiz.com>
X-Mail-Count: 16035

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