"Got a packet bigger than 'max_allowed_packet' bytes" error

pradeepjain

hai guys i am facing a small problem...
i am trying to upload a file of size 4mb .....but i am getting this error
"Got a packet bigger than 'max_allowed_packet' bytes"

how to solve this

Thanks ,
pradeep

mwasif

Are you only uploading a file or saving it to MySQL DB? You can send only a limited data in a single query, this limit is defined by max_allowed_packet in MySQL configuration file. To know the limit, run the following query.

Expand|Select|Wrap|Line Numbers

SHOW VARIABLES LIKE 'max_allowed_packet';

This link will help you to change this limit.
http://dev.mysql.com/doc/refman/5.0/...too-large.html

"Got a packet bigger than 'max_allowed_packet' bytes" error

re: "Got a packet bigger than 'max_allowed_packet' bytes" error

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about