Cannot Import SQL Database for Wordpress website

Avatar
  • Answered
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
Avatar
-2
Arn
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.