ERROR 2006 (HY000): MySQL server has gone away

by 
max_allowed_packet=64M

Adding this line into my.cnf file solves my problem.

This is useful when the columns have large values, which cause the issues, you can find the explanation here.

On Windows this file is located at: “C:\ProgramData\MySQL\MySQL Server
5.6”

On Linux (Ubuntu): /etc/mysql

More Related Contents:

  1. how to get result form mysql query in specific ids [closed]
  2. Why can’t this entry be added because of Foreign Key error?
  3. How to solve “Error: MySQL shutdown unexpectedly”?
  4. What is the ideal data type to use when storing latitude / longitude in a MySQL database?
  5. Left Join not returning all rows
  6. Storing JSON in database vs. having a new column for each key
  7. Maximum length for MySQL type text
  8. Groupwise maximum
  9. How to count words in MySQL / regular expression replacer?
  10. gem install: Failed to build gem native extension (can’t find header files)
  11. Filter by COUNT(*)?
  12. MySQL automatically cast/convert a string to a number?
  13. How to select rows that have current day’s timestamp?
  14. MySQL concatenation operator
  15. LEFT JOIN only first row
  16. How to Convert UTC Date To Local time Zone in MySql Select Query
  17. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  18. MySql – Way to update portion of a string?
  19. How to hack MySQL GROUP_CONCAT to fetch a limited number of rows?
  20. Using reserved words in column names
  21. MySQL INNER JOIN select only one row from second table
  22. How to select only date from a DATETIME field in MySQL?
  23. MySQL connection over SSH tunnel – how to specify other MySQL server?
  24. Storing IPv6 Addresses in MySQL
  25. How to remove constraints from my MySQL table?
  26. Defining Composite Key with Auto Increment in MySQL
  27. mysql Failed to read auto-increment value from storage engine
  28. Alter table if exists or create if doesn’t
  29. How to use Table output from stored MYSQL Procedure
  30. Get total hours worked in a day mysql

Leave a Comment