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

> -----Original Message-----
> From: Jeff Mutschler | M Media [mailto:Jeff_Mutschler (at mark) mmediausa.com]
> Sent: Tuesday, September 15, 2009 7:06 PM
> To: coba-e (at mark) bluequartz.org
> Subject: [coba-e:16037] Re: Restoring a record from a RaqBackup MySQL dump
> 
> 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 was able to restore the thread up until last night update, don't know if I
lost any posts after midnight. About 200 records into vbb_thread, vbb_post,
vbb_postparsed and vbb_threadviews.  In single SQL import and it was back.

I have a HP box here I have BX on that I am getting ready to sent to Chris,
so I uploaded the 1GB sql dump to it and imported it into that server's
MySQL database.  Ended up butching up MySQL on that box (probably jamming
another server's records onto the empty server) but I was able to get it
back running in a little while thanks to Michael's information here:

http://www.solarspeed.net/otrs/public.pl?Action=PublicFAQ&ItemID=27

All in all it took about an hour to fix the missing thread yet even longer
to fix MySQL on the new server.  It wouldn't recognize the root user's
password, but I got it fixed.