> Anyone any idea how to check whether a table is locked? In > particular I use > FLUSH TABLES WITH READ LOCK before backup starts and want to know whether > this has happened. > > Thanks in advance, > > . : Fran Thomas
Fran I don't believe there is any method to show the lock status of a table - well at least not one that can be queried at the SQL level... I guess you could kludge it by using calls to GET_LOCK(),RELEASE_LOCK() instead ... HTH Rich -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
