MySql DeadLock!!!!

I was thinking before that i will never find situations like deadlock. But today i get trapped

What happened i was working in mysql while restoring database from backup "which was in write lock" i found need to kill the process. when i do so "kills the process but never release lock" database become of no use because i cant run query "use table" here how i solve it


try 1.

i run the mysql with -A option

now i was able to use table but even execution of query "unlock tables" was not solution as other queries was already in process

try 2

i try to find which queries are in process and which process is holding lock

ps was of course not a solution

so i found "show processlist" which give me all details about the queries in queue with pid now simply typing kill from sql prompt solves the problum