skip to Main Content

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


  1. 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 use kill <pid> query (replace the with the actual process ID) to kill that query.

    Login or Signup to reply.
  2. 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.

    Login or Signup to reply.
Please signup or login to give your own answer.
Back To Top
Search