How to fix the error "Transferred value is too big. Increase MySQL max packet size..."

The error mostly caused by BLOB values that are larger than max_allowed_packet. Sometimes you may see "packet too large" as part of the error message, and that confirms that you need to increase max_allowed_packet value. You can increase MySQL max allowed packet size with one of the following options:

1. restarting server daemon as

   mysqld --max_allowed_packet=16M

2. running the following query though mysql client

   SET GLOBAL max_allowed_packet=16M

3. setting max_allowed_packet in option file ("my.ini" or "my.cnf")

   [mysqld]
   max_allowed_packet=16M

   Have more questions? Contact us