Re: packet too large, blob over 16MB ?

[Mark Matthews]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Paul Tomsic wrote:
> according to the docs online, the max. packet for
> MySql
> is 16MB.
> What if I'm trying to put in a file that's 25MB as a
> blob?
> 
> is there an alternative?


Yes, use MySQL-4.0 or newer in combination with MySQL Connector/J 3.0 
(3.0.5 is the latest) or newer. You can set the max packet size up to 2GB.

	-Mark


- -- 
MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/

For technical support contracts, visit https://order.mysql.com/?ref=mmma

     __  ___     ___ ____  __
    /  |/  /_ __/ __/ __ \/ /  Mark Matthews <mark@stripped>
   / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
  /_/  /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
         <___/ www.mysql.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.1.90 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQE+Sr9AtvXNTca6JD8RAnTBAJ0VEmdgg7EFPVWzVEHkrzcYJ0+kQgCfQg+w
DZaosY0kMYH5+fhsL0ghRks=
=p9N5
-----END PGP SIGNATURE-----