List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 10 2003 10:48pm
Subject:Re: innodb hot backup
View as plain text  
At 12:50 -0700 5/10/03, Gustavo A. Baratto wrote:
>the manual just says that we can use the innodb hotbackup tool, or 
>shutdown completely mysql and copy the files...
>
>Can't we just "flush tables with read lock", copy the innodb data, 
>log and frm files, then unlock?

FLUSH TABLES locking happens above the level at which InnoDB is aware
of locks, so it doesn't apply to InnoDB tables.  That's my understanding,
anyway.  Heikki will correct me if I'm wrong...

>thanks


-- 
Paul DuBois
http://www.kitebird.com/
sql, query
Thread
innodb hot backupGustavo A. Baratto10 May
  • Re: innodb hot backupPaul DuBois11 May
Re: innodb hot backupHeikki Tuuri11 May
  • Re: innodb hot backupRene van de Weerd12 May
Re: innodb hot backupGustavo A. Baratto13 May
Re: innodb hot backupHarald Fuchs13 May
Re: innodb hot backupGustavo A. Baratto14 May