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
