Page 1 of 1

LONGBLOB,MEDIUMBLOB Mysql server has gone away

Posted: Thu 28 Apr 2005 14:22
by Jeffl
Trying to copy a file streem into a blob field fails with the message "Mysql has gone away" if the file is above 800K. Tried various versions from 4.017 to 5.x with same result. Both MyIsam and Innodb . This may be a comms buffer setting in Mysql. Anyone fixed this ?
Jeff

LONGBLOB,MEDIUMBLOB Mysql server has gone away fix

Posted: Thu 28 Apr 2005 14:34
by Jeffl
Turns out to be server side. The server needs
max_allowed_packet=16M
in the mysql.ini file
Sorry for the waste of time