RE: [PHP-WIN] MySQL Table Locks

2003-03-07 Thread Rich Gray
> 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 -

FW: [PHP-WIN] MySQL Table Locks

2003-03-07 Thread fran . thomas
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 Internet communications are not secure and therefore the Barclays Group does not accept lega

[PHP-WIN] MySQL Table Locks

2003-03-06 Thread fran . thomas
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 Internet communications are not secure and therefore the Barclays Group does not accept lega