ERROR 1153 (08S01) at line 1593: Got a packet bigger than 'max_allowed_packet' bytes

ERROR 1153 (08S01) at line 1593: Got a packet bigger than 'max_allowed_packet' bytes

or

[MySQL] Error Code: 2006 - MySQL server has gone away

mysql 복구 할때 위와 같이 에러가 뜬다면

설정값을 늘려주면 된다.

mysql> set global max_allowed_packet=1000000000;

mysql> set global net_buffer_length=1000000;