Got a packet bigger than 'max_allowed_packet' bytes

Submitted by CoolGoose on Tue, 02/09/2010 - 15:56

Tried importing today an exported sql from a client and I got this nice error

  1. Got a packet bigger than 'max_allowed_packet' bytes

It's easily fixable by editing the "my.cnf" file and adding the "max_allowed_packet" option

  1. [mysqld]
  2. max_allowed_packet=10M

Restart mysql and you're good to go.

Technology: 
mysql

Add new comment