twebman Posted April 20, 2007 Share Posted April 20, 2007 I have two tables in my DB that are marked as "in use" and I cannot query them, open them via PHP My Admin, or anything. I understand from some research that is means the tables are locked or stuck open. What can I do to resolve this issue? Quote Link to comment https://forums.phpfreaks.com/topic/47954-table-in-use-message-how-to-unlock/ Share on other sites More sharing options...
bubblegum.anarchy Posted April 20, 2007 Share Posted April 20, 2007 UNLOCK TABLES ? Quote Link to comment https://forums.phpfreaks.com/topic/47954-table-in-use-message-how-to-unlock/#findComment-234363 Share on other sites More sharing options...
veridicus Posted April 21, 2007 Share Posted April 21, 2007 If you're absolutely sure they shouldn't really be in use I'd use the mysqladmin to safely shut down mysql. Then start it again and check. Quote Link to comment https://forums.phpfreaks.com/topic/47954-table-in-use-message-how-to-unlock/#findComment-234384 Share on other sites More sharing options...
twebman Posted April 21, 2007 Author Share Posted April 21, 2007 Thanks, veridicus. I should have mentioned that I have restarted mysql. Is there something I can do within PHPmyAdmin? What would I do to unlock the tables? Sorry, I have tried some UNLOCK commands, but get bad syntax errors. Quote Link to comment https://forums.phpfreaks.com/topic/47954-table-in-use-message-how-to-unlock/#findComment-234890 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.