Lost connection to MySQL server during query? [duplicate]

by

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

More Related Contents:

  1. left join query keep a column empty
  2. what will be the sql query code of this “Healthcare” database?
  3. Rank function in MySQL
  4. MySQL 8.0 – Client does not support authentication protocol requested by server; consider upgrading MySQL client
  5. Can’t connect to MySQL server error 111 [closed]
  6. Find nearest latitude/longitude with an SQL query
  7. How to store arrays in MySQL?
  8. Include headers when using SELECT INTO OUTFILE?
  9. ERROR 1130 (HY000): Host ” is not allowed to connect to this MySQL server [duplicate]
  10. Subqueries with EXISTS vs IN – MySQL
  11. MySQL timezone change?
  12. ON DUPLICATE KEY + AUTO INCREMENT issue mysql
  13. What is this operator in MySQL?
  14. Cronjob or MySQL event?
  15. How to insert BLOB and CLOB files in MySQL?
  16. 60 million entries, select entries from a certain month. How to optimize database?
  17. How to start spring-boot app without depending on Database?
  18. Is it possible to GROUP BY multiple columns using MySQL?
  19. MySQL compare DATE string with string from DATETIME field
  20. MySQL remote connection fails with “unknown authentication method”
  21. Import MySQL database into a SQL Server
  22. How does MySQL’s ORDER BY RAND() work?
  23. How create json format with group-concat mysql?
  24. DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled
  25. Can’t access mysql from command line on a Mac
  26. MySQL vs. JSON – Why? [closed]
  27. Should I always prefer MySQL InnoDB over MyISAM?
  28. MySQL add 12 hours to a time field
  29. OSX ld: library not found for -lssl
  30. MySQL: Find Missing Dates Between a Date Range

Leave a Comment