[rt-users] UGLY EMERGENCY

[Aubrey King]

OK.. well.. my backup had the MYD, MYI and frm files from the old rt2 
database and I can read them just fine, which is good.  NOW.. I know I 
could surf around and find rt2 to rt3 database conversion scripts, but I'm 
really hoping someone here can help me with a shortcut on that.  Anyone?  
Bueller?

Thank you all, in advance.

Aubrey King
Global Crossing, Ltd.
IP Systems Engineering
Systems Administrator

On Mon, 9 Aug 2004, Kelly F. Hickel wrote:

> OK, well, there should be many files in the directory that has the same
> name as the database.  You're going to have to start by copying those
> onto a shutdown, but working mysql machine (obviously make sure you have
> a copy of the copy!).  I'd probably just try bringing it up first to see
> if it automatically replays whatever transaction logs exist, but you can
> also check the mysql manual, I think there's probably a way to tell it
> to do that explicitly.
> 
> What state do you think the database was in at the time of this copy?
> Was mysql running?  Were transactions (especially write) likely to be
> running on the database?  If you were in the middle of your upgrade from
> RT2 to RT3, had you done the database step yet?
> 
> 
> Also, for the future, you'll REALLY want to check out the hotcopy
> script.  It's nice, easy, and fast....
> 
> -Kelly
> 
> -----Original Message-----
> From: Aubrey King [mailto:aking at gblx.net] 
> Sent: Monday, August 09, 2004 8:36 PM
> To: Kelly F. Hickel
> Cc: rt-users at lists.bestpractical.com
> Subject: RE: [rt-users] UGLY EMERGENCY
> 
> 
> Unfortunately, all we have is the file that the database was stored in 
> under /usr/local/mysql/data or wherever.  This sucks.
> 
> Aubrey King
> Global Crossing, Ltd.
> IP Systems Engineering
> Systems Administrator
> 
> On Mon, 9 Aug 2004, Kelly F. Hickel wrote:
> 
> > How did you do your backup? If you used the mysql HotCopy, you're in
> > luck.  Both because the restore is easy, and I happened to do it last
> > week.  With hotcopy, it makes exact copies of the databases, so all
> you
> > have to do is take mysql down, copy the "rt3" directory from your
> > hotcopy (or whatever your database name was) to wherever your mysql
> data
> > directory is (like /var/lib/mysql/rt3), and bring mysql back up...
> > 
> > -Kelly
> > 
> > -----Original Message-----
> > From: rt-users-bounces at lists.bestpractical.com
> > [mailto:rt-users-bounces at lists.bestpractical.com] On Behalf Of Aubrey
> > King
> > Sent: Monday, August 09, 2004 8:08 PM
> > Cc: rt-users at lists.bestpractical.com
> > Subject: [rt-users] UGLY EMERGENCY
> > 
> > 
> > We have been happily running an instance of RT2 (and rt1 before that)
> > here 
> > at Global Crossing for several years and, this morning, we had a 
> > catastrophic event happen.. every admin's worst nightmare.  After
> having
> > 
> > one of two mirrored drives fail, I got right on my new machine to
> > upgrade 
> > to rt3 instead of replacing the drive (we're a poor company nowadays).
> 
> > Well, this am, after a power hit which took out our ac, the
> temperatures
> > 
> > rose in our data center (110 degrees +) and my last drive failed.
> Now,
> > I 
> > have nothing but a backup of the rt2 database from /usr/local/mysql. 
> > 
> > Has anyone had any experience with this?  I need to get my old data
> from
> > 
> > there (and /opt, which was backed up, too), but I'm not sure if anyone
> > has 
> > a nice script that can just magically import my old stuff from that
> into
> > 
> > mysql again, but in rt3 format.
> > 
> > Anyone?
> > 
> > Aubrey King
> > Global Crossing, Ltd.
> > IP Systems Engineering
> > Systems Administrator
> > _______________________________________________
> > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> > 
> > Be sure to check out the RT wiki at http://wiki.bestpractical.com
> > 
> > 
> 
>