Dhibi_Mohanned Dhibi_Mohanned - 3 years ago 172
MySQL Question

MySQL Database Error: Packets larger than max_allowed_packet are not allowed when insert

I have installed mysql server 5.1. I am having a problem with BLOB fields in my MySQL database when i try to insert a huge file. Does anybody have any suggestion?

Thanks a lot in advance

Answer Source

How to fix this problem :

change the value of the max_allowed_packet variable in the configuration of your MySQL server.

How to know how much over what's allowed you are : not sure, but I would say that checking the size (in bytes) or your insert query should give you an idea.

For more informations, you should take a look at the following section of the MySQL manual : C.5.2.10. Packet too large.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download