The problem is that you are starting mysql with the wrong
arguments. I think you need to set the max_allowed_packet
parameter to something larger than the default 1 M. I got
mine to do that by using this command:
safe_mysqld --user=mysql -O key_buffer=16M -O table_cache=128 -O sort_buffer=4M -O
r
> Whenever I insert data that is
> around 1 Megabyte in size, I get an error saying
> "MySQL server has gone away". It doesn't happen with
> smaller data, and even if I change the column type to
> LONGBLOB I still have this problem.
You've hit the default maximum packet size of 1 MB.
This is a pr
- Original Message -
From: "Steven Nakhla" <[EMAIL PROTECTED]>
To: "QT" <[EMAIL PROTECTED]>
Cc: "MySQL" <[EMAIL PROTECTED]>
Sent: Monday, November 04, 2002 3:47 PM
Subject: MySQL and binary data
> I am using Qt 3.0.5's QSql dat
I am using Qt 3.0.5's QSql database classes to store
information in a MySQL database. MySQL is at version
3.23.49. I am trying to store binary data into a
column marked as MEDIUMBLOB (or even LONGBLOB) but am
having difficulties. Whenever I insert data that is
around 1 Megabyte in size, I get an