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
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
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 indexes for
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
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 co
> 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.
--Original 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: Jerem
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 probl
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 repl
