List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:August 31 2002 2:51am
Subject:Re: Tape backups from live slave
View as plain text  
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?
>
>That should work.  I assume you're going to use "FLUSH TABLES WITH
>READ LOCK" to do it?

But note that this will have no effect on InnoDB tables, because the
InnoDB handler isn't affected by that statement.

>
>Just make sure the session doesn't timeout--MySQL will release the
>lock when it disconnects.
>
>Jeremy
>--
>Jeremy D. Zawodny     |  Perl, Web, MySQL, Linux Magazine, Yahoo!
><Jeremy@stripped>  |  http://jeremy.zawodny.com/
>
>MySQL 3.23.51: up 24 days, processed 512,136,338 queries (240/sec. avg)

Thread
Tape backups from live slaveJeremy Tinley30 Aug
  • Re: Tape backups from live slaveWilliam R. Mussatto30 Aug
    • RE: Tape backups from live slaveJeremy Tinley30 Aug
      • Re: Tape backups from live slaveMike Hall31 Aug
        • Re: Tape backups from live slavePaul DuBois31 Aug
        • RE: Tape backups from live slaveJeremy Tinley31 Aug
      • RE: Tape backups from live slaveWilliam R. Mussatto31 Aug
  • Re: Tape backups from live slaveJeremy Zawodny31 Aug
    • Re: Tape backups from live slavePaul DuBois31 Aug