Re: MySQL Error for Blobs

[Dan Buettner]

max_allowed_packet is the maximum size of a single SQL statement.
It's a setting on the server, as well as for the mysql command line
interface.

See http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html

I think 1 MB is the default; the maximum setting for MySQL 5 is 1 GB.
You can adjust this setting in the server config files (my.cnf or
my.ini). I do not know if you need to adjust anything in Navicat,
ODBC, Query Browser or Access - sorry!

Dan

On 11/16/06, C K <shrees...@gmail.com> wrote:
> I got an error while entering an BMP image of 1.7MB size in a
> mediumblob field through MS Access 2003 with MyODBC 3.51.12
> on Windows XP SP2 also with MySQL Query Browser
> and Navicat GUI tool. Navicat returned the error as 'Got a packet bigger
> than Max_allowed_packet bytes'. What this means?. Access and Query browser
> simple gives error as MySQL has gone away? Why? please help. Also please
> give a solution if we have to insert
> images/Other Objects of size more than 1 MB what we have to do using ODBC
> driver with/without MS Access & VB.net?
> Thanks
> CPK
>
>

--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=myo...@freebsd.csie.nctu.edu.tw

[Jerry Schwartz]

When a query exceeds the size of the maximum allowed packet, mysqld closes
the connection. It assumes something has gone wrong with the client. There
are two max_allowed_packet variables, one for the server and one for the
client. This is documented in section A.2.9 of the documentation
http://www.mysql.org/doc/refman/4.1/en/packet-too-large.html

Regards,

Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341