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?.
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
To: mysql@lists.mysql.com; [EMAIL PROTECTED]
Subject: MySQL Error for Blobs
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