I’ve executed the copy table operation from PhpMyAdmin and it is taking too long (big table), and now the original and new table are not responding (I can browse the other tables in PhpMyAdmin)
I think because maybe there is a read lock or something worst, is possible to cancel the operation or see at least what’s happening?
2
Answers
Two possible things – first, you could restart the webserver to stop any running PHP scripts. That might help if PHPMyAdmin copies the data in batches.
Second, you can execute
show full processlist
query to see all running queries. Identifying the hung query should not be too hard. Then usekill <pid>
query (replace the with the actual process ID) to kill that query.On phpMyAdmin’s main page, go to Status > Processes. You should be seeing one process with a large value under Time; use the Kill link to stop it.