Re: i have a problem inserting blob data larger than 1 mb

sunaram patir wrote:

hi list, i am facing a problem inserting binary data into a blob field.this is my /etc/my.cnf file. [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock connect_timeout=60 [mysql.server] user=mysql basedir=/var/lib [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid please help me. and this is what i get after running the comand mysql --help ....................... ....................... ....................... Possible variables for option --set-variable (-O) are:

connect_timeout       current value: 0
max_allowed_packet    current value: 16777216
net_buffer_length     current value: 16384
select_limit          current value: 1000
max_join_size         current value: 1000000

i guess there is some problem with connect_timeout.

Blobs have a max size like every other variable. Have you tried mediumblob and longblob yet? They both have more capacity. I suggest you refer to the MySQL manual. Regards, Adam Zey.