LONGBLOB,MEDIUMBLOB Mysql server has gone away

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Jeffl
Posts: 5
Joined: Thu 28 Apr 2005 10:07

LONGBLOB,MEDIUMBLOB Mysql server has gone away

Post by 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

Post by 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

Post Reply