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/[email protected]