Forums | Webyog
Tools to manage and monitor MySQL databases
forums › forums › SQLyog › Using SQLyog › Largest Size Blob
I went to these web sites:
http://www.mysql.com/doc/en/Gone_away.html
http://mysql.tviund.is/doc/en/Packet_too_large.html
I tryed this command below:
C:mysqlbin>mysqld -o max_allowed_packet=5M
It doesn't seem to work. Anybody know what I'm doing wrong?
Thanks,
Ray
Hello
Try this line in the [mysqld] section of your my.cnf
set-variable = max_allowed_packet=16M
We store around 3-4MB of binary data in BLOB fields without any problem 🙂
Cool, thanks Ritesh it worked great. I added set-variable = max_allowed_packet=16M to my.ini and restarted my computer, and it worked 🙂