From:       To:      
Home > Documentation > MySQL

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