re: [Fwd: possible problems with FLUSH TABLES WITH READ LOCK]

Hello Victoria, > You need to do it with 2 sessions. > > According MySQL manual: > > If you are using a Veritas filesystem, you can do: > >1. From a client (or Perl), execute: FLUSH TABLES WITH READ LOCK. >2. From another shell, execute: mount vxfs snapshot. >3. From the first client,

re: [Fwd: possible problems with FLUSH TABLES WITH READ LOCK]

I can't really A> take the system down for a 4-hour tape backup... ;( A> Message original ---- A> Sujet: possible problems with FLUSH TABLES WITH READ LOCK A> De: "Antoine" <[EMAIL PROTECTED]> A> Date: Mar, 26 Novembre 2002, 17:27 A> A: <[EMAIL

[Fwd: possible problems with FLUSH TABLES WITH READ LOCK]

essage original ---- Sujet: possible problems with FLUSH TABLES WITH READ LOCK De: "Antoine" <[EMAIL PROTECTED]> Date: Mar, 26 Novembre 2002, 17:27 A: <[EMAIL PROTECTED]> Hi, I am using FLUSH TABLES WITH READ LOCK to get consistent snapshots of my database without shutt

possible problems with FLUSH TABLES WITH READ LOCK

Hi, I am using FLUSH TABLES WITH READ LOCK to get consistent snapshots of my database without shutting it down. The setup is : - bi-P4 Xeon with Redhat 7.3 - 2.4.19 kernel with properly patched LVM (compiled from source) - MySQL server 4.0.4 (compiled from source) - ext3 filesystem on a 44 GB L