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

Reply via email to