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

2002-11-29 Thread Victoria Reznichenko
Antoine, Thursday, November 28, 2002, 4:17:48 PM, you wrote: A Sorry to insist, but nobody has any clues about this ? A I can supply further info if needed. A Is the FLUSH TABLES WITH READ LOCK functionality well tested ? A Having corrupted backups is annoying, and I can't really A take the

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

2002-11-29 Thread Antoine
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,