Thursday, September 10, 2009

How to solve Error 2006 - mySQL server has gone away.

When I need to populate data into mysql database, I got this error; Error 2006 - mySQL server has gone away.

How to solve it?

....\xampp\mysql\bin
open my.cnf > drag the icon into Notepad


Then just change the value of max_allowed_packet. In my case, I set 600M.



Save. And restart mysql server.