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

Reply via email to