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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]