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
dobromir@stripped
http://www.websitepulse.com/
