Hi!
I've to upload in a database a blob that is about 80K and the system respond with an error message "Mysql server has gone away".
I've read some previous posts and the manual that explain:
"...You can also get these errors if you send a query to the server that is incorrect or too large. If mysqld gets a packet that is too large or out of order, it assumes that something has gone wrong with the client and closes the connection. If you need big queries (for example, if you are working with big BLOB columns), you can
increase the query limit by starting mysqld with the -O max_allowed_packet=# option (default 1M)...".
My problem is that I'm using an hosted account and i think i cannot restart mysqld with the option that i want (or I can?)
Any other idea to set the option max_allowed_packet or to resolve the problem in another way?
Thanks,
Gaetano
I've to upload in a database a blob that is about 80K and the system respond with an error message "Mysql server has gone away".
I've read some previous posts and the manual that explain:
"...You can also get these errors if you send a query to the server that is incorrect or too large. If mysqld gets a packet that is too large or out of order, it assumes that something has gone wrong with the client and closes the connection. If you need big queries (for example, if you are working with big BLOB columns), you can
increase the query limit by starting mysqld with the -O max_allowed_packet=# option (default 1M)...".
My problem is that I'm using an hosted account and i think i cannot restart mysqld with the option that i want (or I can?)
Any other idea to set the option max_allowed_packet or to resolve the problem in another way?
Thanks,
Gaetano