longblob insert question

Hi,
I am trying to insert a longblob (in this case a
string of characters) into a table, using perl:dbi .
The mysql instance is located on a solaris box.

My load script keeps failing, I get a the following
error:

Got a packet bigger than 'max_allowed_packet'! at
DataAccessObject.pm line 1063.

I changed the max_allowed_packet size in the my.cnf
file to 1 G, but that didn't fix the problem.

I am doing a standard insert :
like : (simplified)
"insert into feature (sequence) values (?)";

my $sequence = $featuretable->sequence();

$insert->bind_param( 1, $sequence );


I wonder if there is some sort of append function, or
a way to divide the data stream into chunks? Or should
I store the chunks in a temporary table and try to
merge them later?


I would really appreciate any guidance on this issue.

Regards,
Renee








____________________________________________________
Yahoo! Sports
Rekindle the Rivalries. Sign up for Fantasy Football
http://football.fantasysports.yahoo.com

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org