MySQL server has gone away

March 3, 2011 · Posted in mysql · Comment 

While importing a mysql dump file, I was receiving an error “MySQL server has gone away”. The reason is that the maximum allowed packet size was less than the dump file size.

Edit “my.ini” file and update the value for
max_allowed_packet = XXM
where XX is the maximum size.

This should fix the issue.

Tags: no tags

  • Calendar

    March 2011
    M T W T F S S
    « Feb   Jun »
     123456
    78910111213
    14151617181920
    21222324252627
    28293031