Jump to content

2006 - "MySQL server has gone away" error


Mad_Griffith

Recommended Posts

Hi everybody, I am trying to import a db in myphpadmin which works fine on another server and I get the error below. Can you tell me what's wrong here? Thank you.

 

Roughly translated it s:

 

Static analysis:

1 error was found during analysis.

  1. Keyword not recognized. (near "ON" at position 25)

SQL Query:

SET FOREIGN_KEY_CHECKS = ON;

MySQL message:

#2006 - MySQL server has gone away

Link to comment
Share on other sites

That error can mean several things but it will often happen if the query packets are too large. Try breaking up your query into smaller pieces. If it's complaining about "ON" being there then use a 1 or 0 instead of on and off.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...