Hi, This procedure works for me and until now I haven't had any problems with it. You should b aware that if your database is under heavy load you might experience problems with transactions timing out due to the lock.
HTH On Wednesday 27 July 2005 09:14, Jeff Richards wrote: > Hi, > > I need a procedure that will allow me to take an online (i.e. database > up) Netapp Snapshot of a large InnoDB-based database. Could someone > please confirm that this is a valid way of making a Snapshot: > > * Issue a "flush tables with read lock;" > * Issue a "flush logs;" > * Create the Snapshot > * Issue an "unlock tables;" > > The reason I ask is that this list is the only place I can find > reference to this procedure. Everywhere else talks about either > mysqldump or the InnoDB Hot Backup utility for making online backups. > > Thanks in advance! > > Jeff > > -- > Jeff Richards > Consulting Architect > Openwave Systems Asia Pacific > +61 415 638757 -- Dobromir Velev [EMAIL PROTECTED] http://www.websitepulse.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]