[rt-users] RE: UGLY EMERGENCY

[Richard Ellis]

> Message: 1
> Date: Mon, 9 Aug 2004 20:33:11 -0500
> From: "Kelly F. Hickel" <kfh at mqsoftware.com>
> Subject: RE: [rt-users] UGLY EMERGENCY
> To: "Aubrey King" <aking at gblx.net>
> Cc: rt-users at lists.bestpractical.com
> Message-ID:
> 	<3C05BBBA1B54ED43B1A6827E620EF1CD58551F at mailservermn.mqsoftware.com>
> Content-Type: text/plain;	charset="us-ascii"
> 
> 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
> 
This is an awesome tip from Kelly. We were using Mysqldump every 6 hours
for backups, which is not exactly the quickest way to do it but it
worked. Tried mysqlhotcopy today and it was sub second ( ok we only have
5000 tickets so far) to complete the backup.

I'm a convert - thanks Kelly