This error can occur often when trying to execute large queries or import large amounts of blob data in a SQL dump. Assuming you have access to the my.ini in your MySQL directory, you need to either add the following line underneath your “[mysqld]” section or increase the size to a greater amount…
max_allowed_packet=10M
The maximum value you may specify is 1GB however setting it to a high amount (ie: 250mb), will not cause any performance issues because MySQL will only use that much if necessary.
NOTE: Make sure you have enough memory on your system to handle the increase in packet size or else you could potentially use swap space thus decreasing the performance of the query.
October 13th, 2008If you (like I), have googled all around trying to figure out this problem to no avail then perhaps my solution will work best for you. Everywhere I r[...] Read the rest »
O comments at "Error: MySQL Server Has Gone Away"
Comment Now!