InMotion Hosting Support Center

Cannot Import SQL Database for Wordpress website


InMotionFans
n/a Points
Asked:
2017-09-19 8:27 pm EST

Hits: 4,267
I'm trying to import a sql database but end up with the following error:

rror
Static analysis:

1 errors were found during analysis.

Missing expression. (near "ON" at position 25)
SQL query: Edit Edit

SET FOREIGN_KEY_CHECKS = ON;

MySQL said: Documentation

#2006 - MySQL server has gone away

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
42,973 Points
2017-09-20 7:02 am EST
Hello,

Sorry for the error #2006 - MySQL server has gone away. This error can happen during an import process for a wide variety of reasons. One of the most common is that the server got disconnected either through an issue at the server, or through a network issue. The problem can be related to a program you're using, or it might be code-related. Per the notes on your account, it appears that you're using an application to do the import. If you're importing a database of over 51 MB, then the application may be timing out because it is taking too long to complete the import. You may need to export the database as an SQL file first, upload it to the server using an FTP client, and then request (technical support) that the database is imported via SSH. You can also review this article on importing large databases with a local installation of phpMyAdmin.

I hope that helps to resolve your issue! If you require further assistance, please let us know.

Regards,
Arnel C.

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

not real helpful. I have the same issue, and I'm just trying to import a posts table...2400Kb (under 3Mb) and what's the foreign key on/off thing? (it doesn't seem to matter, but it would help to know what it should be set to)
watermarkPG
3 Points
2018-10-08 9:14 pm EST
Like this Question?

Forum Login

You are NOT logged in. You can still browse our Support Center.

To participate within our Community Support Forum:

Need more Help?

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!