> 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 protocol option - the MySQL client-server protocol limits itself to packets of a certain size. This is both a client and server option. You need to increase both. Here's what I have in my.cnf, in the [mysql] and [mysqld] sections: set-variable = max_allowed_packet=16M --------------------------------------------------------------------- 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
