It sounds to me that you're exceeding the maximum packet size mysql can handle.
Adriano Manocchia wrote: > > I've been using a perl script to insert a very large blob (up to about 8 > MB) into a DB successfully, but now I need to do it with a 34 MB BLOB, > so I upgraded to MySQL 4.0.1. First off, I can't get > max_allowable_packet to go higher than 64M, regardless of what I set it > to, but that shouldn't be the problem, right? But I still keep getting > > DBD::mysql::st execute failed: MySQL server has gone away > > when it tries to do the insert or update. It continues to work fine for > smaller files. The field is a longblob, BTW. Any help would be greatly > appreciated. And please don't tell me not to store large blobs in the > database. I wouldn't be doing it if I didn't have to. > > Age > > --------------------------------------------------------------- > Adriano "Age" Manocchia [EMAIL PROTECTED] > Cornell University AIM/Yahoo/MSN: SalsaSharkNet > http://salsashark.net/age ICQ: 5962736 > --------------------------------------------------------------- > "The capacity to blunder slightly is the real marvel of DNA. > Without this special attribute, we would still be anaerobic > bacteria, and there would be no music." -Lewis Thomas > > --------------------------------------------------------------------- > 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 -- Colin Faber (303) 859-1491 fpsn.net, Inc. --------------------------------------------------------------------- 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
