During a backup, is there any way to get a normal query to work?
It seems that a backup causes a read lock on the tables.

I'm pondering how to get this to work sensibly - possibly keeping a note
of when the last transaction was and waiting for 10 mins. The backup
should be done in the middle of the night when no one is around, but I'm
also coding it to make a backup 5 mins after opening if it hasn't done one
recently, and of course that's an awkward time if the backup takes a
minute or two.

Any thoughts on this issue welcome!

/Matthew Jones/

Matthew,

<< During a backup, is there any way to get a normal query to work?  It
seems that a backup causes a read lock on the tables. >>

Sure, you should be able to read the tables just fine during a backup.  The
only restriction is that a backup prevents any writes to the tables.

--
Tim Young
Elevate Software
www.elevatesoft.com

Thanks - I'll work out where I'm failing then. Hmm, instant thought is
that I think I write a "last seen" time. I'll stop that if backup is
active and see if that fixes it. Many thanks for the confirmation that it
is me.

/Matthew Jones/