Page 1 of 1
Timeout when uploading large BLOB field
Posted: Mon 08 Nov 2004 14:32
by rfish
When uploading a large blob field to the database, I get the Exception [the database has gone away]. This limits the max upload size of the BLOB field to about 12MBytes. I need to be able to upload larger fields.
Is there somewhere to set this timeout?
Re: Timeout when uploading large BLOB field
Posted: Mon 08 Nov 2004 16:08
by Ikar
Probably, the problem isn't in timeout but in a value of max_allowed_packet at the server.
Try to change a value of this variable. You can read details about it in MySQL Reference Manual.
rfish wrote:When uploading a large blob field to the database, I get the Exception [the database has gone away]. This limits the max upload size of the BLOB field to about 12MBytes. I need to be able to upload larger fields.
Is there somewhere to set this timeout?
Posted: Mon 08 Nov 2004 22:04
by rfish
Max allowed packet at the server is set to 500M (500 Mbytes).
I can use the mysql client to upload larger blob files than I can with the dbexpress component.
Posted: Tue 09 Nov 2004 10:52
by Ikar
Try to do it not in Direct mode. Do you have the same error?