----- 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 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 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. The data I am > trying to insert is an exectuable application, > although I have tried it with a normal text file and > have run into the same problems. Can anyone shed some > light onto what could be causing this problem? > Thanks!! I think you may be running into the "max_allowed_packet" size, which defaults to 1048576 (1M). Beyond that, the mysqld server issues a Packet too large error and closes the connection. Restart the server with the set-variable=max_allowed_packet=16M option, or any other value of your choice. - Mark --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
