MySQL: Inserting large BLOBs (over 16M) using DBI

urizen has asked for the wisdom of the Perl Monks concerning the following question:

I'm trying to insert rather large (some over 16M) files into a BLOB field with MySQL. Unfortunately, while MySQL's LARGEBLOB field will support the files, the protocol the client uses has a 16M limit. Any ideas how to circumvent this (other than breaking the file into smaller pieces and storing in multiple records)?

Comment on MySQL: Inserting large BLOBs (over 16M) using DBI

Replies are listed 'Best First'.
Re: MySQL: Inserting large BLOBs (over 16M) using DBI by gmax (Abbot) on May 18, 2002 at 08:03 UTC
I think that this node might be able to address your needs. Handling huge BLOB fields with DBI and MySQL gmax	[reply]
Re^2: MySQL: Inserting large BLOBs (over 16M) using DBI by soulman2050 (Initiate) on Jun 03, 2005 at 21:23 UTC
This solution requires splitting the file into pieces, is there a way to increase the 16M restraint in perl the way you can increase the max_allowed_packet variable in the MySQL server?	[reply]