I have Bluehost account and now i am transferring to new account digitalocean.com i am doing export and import as we do in the phpmyadmin but here when i import my sql.zip or sql.gz files in new server it show me error like

Error
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

Here is the screen shot

https://www.awesomescreenshot.com/image/2511553/fa78fad9e1108051c84538f2314df7

i do following steps to resolve issue

  1. try to export by MYSQL_40 and import
  2. try by disabling the FOREIGN_KEY checkbox when export and try to import
  3. Used the database plugin but same error

But no luck i think it is an issue with bluehost server when i am trying to export

Read more here: set foreign_key_checks = on error wordpress


Solution:

If you know the solution of this issue, please leave us a reply in Comment section, to update the question.


Wordpress related questions and answers: