I tried running a query and it froze PHPMyAdmin

Category: Databases

InMotionFans
n/a Points
Asked:
2014-01-02 6:39 pm EST

Hits: 172
I was trying to run a query on a large table (40,000 rows), and PHPMyAdmin froze. I closed the tab and tried to reenter it, but I could never get in. I thought about dumping and then deleting the database, but the only way to do that without PHPMyAdmin is to log in using SSH, but since I'm on a shared server I can't do that. Please help!

You must login before you can ask a follow up question.

You must login before you can submit an answer.

OTHER ANSWERS

0

Arn
Staff
18,399 Points
2014-01-02 7:10 pm EST
Hello,

Sorry to hear about your query issues with the database. I have escalated the issue to our Systems team (through live technical support) and it may be several minutes until they can clear all of the connections and queries that you have made in the process of running the query. Systems will need to kill the process in order to allow you to log back into the database through phpMyadmin.

As per your own thought, I would highly suggest that you simply export the database to your local system and then run the query locally. After the query's completed, then you could re-import the database .

The SQL server is probably under a little bit of load so it's probably running into resource issues that are causing the issue you're seeing. If you were still wanting to run that query on the server, you will need to wait until our Systems team clears the existing process so that you can try it once again. If the same issue occurs, then you would need to submit a support ticket to have Systems clear the query again. I don't recommend it if you're aware that it's a large query. If you do try to run it, you may want consider running it later in the evening when usage on the servers are much lower.

We do appreciate your patience on the issue. Please let us know if you require any further assistance.

Regards,
Arnel C.

You must login before you can post a comment about this answer.

Like this Question?

Related Articles

It looks like there are no related articles.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!