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,

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 th

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

2002-11-28 Thread Antoine
Sorry to insist, but nobody has any clues about this ? I can supply further info if needed. Is the "FLUSH TABLES WITH READ LOCK" functionality well tested ? Having corrupted backups is annoying, and I can't really take the system down for a 4-hour tape backup... ;( Message original ---