Well, first off, I can't seem to get max_allowed_packet higher than 64 MB on the server using 3.23.x or 4.0.1. Changes made to /etc/my.cnf are reflected in the system settings, but only up to 64 MB, then regardless of what I put in there, it stays at 64 MB. But like I said, the file is only 34 MB, so theoretically it shouldn't be a problem. As for the client, I'm trying to insert the record with the Perl DBI, which, according the documentation, uses the server's max_allowed_packet value. There's no way to set it on the client side that I'm aware of.
On Saturday, March 30, 2002, at 12:11 PM, Peter Zaitsev wrote: > Hello Adriano, > > Friday, March 29, 2002, 11:38:32 PM, you wrote: > > As I remember there are max_allowed_packet options exists both for > client and server. You may wish to try to raise both of them. > > > AM> I've been using a perl script to insert a very large blob (up to > about 8 > AM> MB) into a DB successfully, but now I need to do it with a 34 MB > BLOB, > AM> so I upgraded to MySQL 4.0.1. First off, I can't get > AM> max_allowable_packet to go higher than 64M, regardless of what I > set it > AM> to, but that shouldn't be the problem, right? But I still keep > getting > > AM> DBD::mysql::st execute failed: MySQL server has gone away > > AM> when it tries to do the insert or update. It continues to work fine > for > AM> smaller files. The field is a longblob, BTW. Any help would be > greatly > AM> appreciated. And please don't tell me not to store large blobs in > the > AM> database. I wouldn't be doing it if I didn't have to. --------------------------------------------------------------------- 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
