Lost connection to MySQL server during query?

Question

(This question already has answers here): question from:https://stackoverflow.com/questions/6516943/lost-connection-to-mysql-server-during-query

Answer 1

Try the following 2 things...

1) Add this to your my.cnf / my.ini in the [mysqld] section

max_allowed_packet=32M

(you might have to set this value higher based on your existing database).

2) If the import still does not work, try it like this as well...

mysql -u <user> --password=<password> <database name> <file_to_import