up vote 0 down vote favorite
share [g+] share [fb]

I am trying to restore a mysql backup using phpmyadmin on a local xampp installation.

However, when I attempt to do so, the query just hangs forever until it times out.

I noticed that the backup has lock table statements; I removed those, but it made no difference.

Is there any suggestion as to [1] what might be causing the query to hang, and [2] how to kill such a long running query?

link|improve this question
100% accept rate
1  
Just a complete shot in the dark here but I have seen problems in the past with phpmyadmin that where solved by increasing max_allowed_packet in /etc/my.cnf and/or upload_max_filesize in /etc/php.ini. Not sure how xampp may effect things. – digitaladdictions Oct 7 '11 at 7:43
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown
discard

Browse other questions tagged or ask your own question.