Howdy,
Before I run off and try it, can anyone offer up any problems with doing
a LOCK TABLES, FLUSH TABLES and then use tar to backup my 16GB of DB
tables from a slave to a tape?
Currently, I redirect the traffic to another slave, and then shut down
this slave to backup the tables and keep
On Fri, 30 Aug 2002, Jeremy Tinley wrote:
Date: Fri, 30 Aug 2002 12:36:28 -0500
From: Jeremy Tinley [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Tape backups from live slave
Howdy,
Before I run off and try it, can anyone offer up any problems with doing
a LOCK TABLES, FLUSH TABLES
Message-
From: William R. Mussatto [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 30, 2002 1:57 PM
To: Jeremy Tinley
Cc: [EMAIL PROTECTED]
Subject: Re: Tape backups from live slave
On Fri, 30 Aug 2002, Jeremy Tinley wrote:
Date: Fri, 30 Aug 2002 12:36:28 -0500
From: Jeremy Tinley [EMAIL
b) I have 200 tables. I don't want to have to recreate indexes for
every table if I have to restore. I'd rather spend an hour restoring
from tape and let replication catch me up.
Why would you have to recreate the indexes? The dump will contain this
information in the CREATE statements.
At 21:13 +0100 8/30/02, Mike Hall wrote:
b) I have 200 tables. I don't want to have to recreate indexes for
every table if I have to restore. I'd rather spend an hour restoring
from tape and let replication catch me up.
Why would you have to recreate the indexes? The dump will contain
On Fri, 30 Aug 2002, Jeremy Tinley wrote:
Date: Fri, 30 Aug 2002 14:02:51 -0500
From: Jeremy Tinley [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: Tape backups from live slave
Good question,
a) The slave does not have the free space to make a duplicate
on the file system
(and subsequently deleting it).
-J
-Original Message-
From: Mike Hall [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 30, 2002 3:14 PM
To: Jeremy Tinley; [EMAIL PROTECTED]
Subject: Re: Tape backups from live slave
b) I have 200 tables. I don't want to have to recreate
On Fri, Aug 30, 2002 at 12:36:28PM -0500, Jeremy Tinley wrote:
Howdy,
Before I run off and try it, can anyone offer up any problems with
doing a LOCK TABLES, FLUSH TABLES and then use tar to backup my 16GB
of DB tables from a slave to a tape?
That should work. I assume you're going to use
At 17:05 -0700 8/30/02, Jeremy Zawodny wrote:
On Fri, Aug 30, 2002 at 12:36:28PM -0500, Jeremy Tinley wrote:
Howdy,
Before I run off and try it, can anyone offer up any problems with
doing a LOCK TABLES, FLUSH TABLES and then use tar to backup my 16GB
of DB tables from a slave to a tape?