Re: MAX_ALLOWED_PACKET and BLOBS

[John Zandbergen]

After rereading your problem, maybe this is a solution?

1. Create a file mysettings.cnf. This file should be copied to the client's computer (or better: created with your program). This file should contain the following:

[client]
set-variable = max_allowed_packet=10M

2. Doe this when opening the connection:

mysql = mysql_init(NULL);

res = mysql_options(mysql, MYSQL_READ_DEFAULT_FILE, "/mysettings.cnf");


I debugged it and found that mysql->net.max_packet_size is 1073741824. That should be 10M. I'm not able to test if it really runs with the big blobs...

Hope this help (you more),
John