<div>
Thank you for the info.<br />
it's what I was looking for.
</div>


Thank you for the info.
it's what I was looking for.

<div>
<div class="content wysiwyg-content">
okay, so mysql long text is 4 G.<br />
however, since the max_alllowed_packet &nbsp;max value is 1G, how do you USE the 4G?<br />
especially in a java app, without running into errors?<br />
<br />
currently, I am dumping data from a mssql database into a mysql database, and kept running into errors, until I jacked it up to 1G. &nbsp;Now, I only have a few errors, so how is it supposed to be used, if there's a 1G limit on the amount of data that can be accepted through a query?
</div>
</div>


okay, so mysql long text is 4 G.
however, since the max_alllowed_packet  max value is 1G, how do you USE the 4G?
especially in a java app, without running into errors?

currently, I am dumping data from a mssql database into a mysql database, and kept running into errors, until I jacked it up to 1G.  Now, I only have a few errors, so how is it supposed to be used, if there's a 1G limit on the amount of data that can be accepted through a query?

mysql Long text and net packet limit

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.