[rt-users] UGLY EMERGENCY

[Kelly F. Hickel]

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