connection lost when transfering larger files to mysql 5.19 using dbexpmda3

ginger · Post by **ginger** » Fri 24 Mar 2006 15:15

i'm using delphi 2006 with dbexpmda30.dll version 3.0.1.0, whem i try to save a larger file (over 300kb) tot the mysql 5.19 database my connection is lost

what's wrong? (i'm using direct connection, when using libmysql, problem also occurs)

Antaeus · Post by **Antaeus** » Fri 24 Mar 2006 16:00

Maybe this problem is concerned to MySQL server global variable max_allowed_packet. Try to set it to a value that is greater than file size you try loading. For example:
SET GLOBAL max_allowed_packet = 5*1024*1024;

ginger · Post by **ginger** » Tue 28 Mar 2006 12:42

I tried to work with this option, now it's okay up to 500kb. But i need larger files (up to at least 2mb).

What more can I try?

Antaeus · Post by **Antaeus** » Wed 29 Mar 2006 06:18

Value of the max_allowed_packet variable shouldn't match maximum size of the file posting to the server, it should be greater than file size. Try to increase value of the max_allowed_packet variable some more. If the problem persists, please report us what error message are you getting.