Largest Size Blob

[krzyray]

Hello,

So far I have been using SQLyog, and it's a great program.

I am trying to store a 1.5mb PDF file in a blob datatype. I keep getting this error:

Error No. 2006

MySQL server has gone away

Does anybody know what the max size can be stored in a blob field? or where in SQLyog can you change the size of a blob datatype?

Thanks,

Ray

[krzyray]

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

[Ritesh]

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 🙂

[krzyray]

Cool, thanks Ritesh it worked great. I added set-variable = max_allowed_packet=16M to my.ini and restarted my computer, and it worked 🙂

Ray

[Author]

Posts