LONGBLOB,MEDIUMBLOB Mysql server has gone away

LONGBLOB,MEDIUMBLOB Mysql server has gone away

Postby Jeffl » Thu 28 Apr 2005 14:22

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
Jeffl
 
Posts: 5
Joined: Thu 28 Apr 2005 10:07

LONGBLOB,MEDIUMBLOB Mysql server has gone away fix

Postby Jeffl » Thu 28 Apr 2005 14:34

Turns out to be server side. The server needs
max_allowed_packet=16M
in the mysql.ini file
Sorry for the waste of time
Jeffl
 
Posts: 5
Joined: Thu 28 Apr 2005 10:07


Return to MySQL Data Access Components