Does anyone know how to unlock tables in MySQL when the connection is lost (it was a mysql_pconnect )? I was running a script that locked a couple of tables in my database. This script was interupted before it ran the UNLOCK TABLES query. Now I can't access any of the site that links to the database and when I try to access the tables directly though MySQL-Front it just freezes.
Have tried to run a new script with an UNLOCK query but it hasn't worked (I'm guessing because its not the same connection).
Is my only option to ask for the server to be restarted?
I'd be grateful for any suggestions cos I'm stumped!