• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 534
  • Last Modified:

mysql Long text and net packet limit

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?
0
Connie McBride
Asked:
Connie McBride
1 Solution
 
johanntagleCommented:
Looks like you have to insert the row without the long text field, split the long text within your application then update the row by sending the splitted parts in succession.  See the bottom entries of the following pages:

http://bugs.mysql.com/bug.php?id=22853
http://www.codingforums.com/archive/index.php/t-56289.html
0
 
Connie McBrideJust a simple programmerAuthor Commented:
Thank you for the info.
it's what I was looking for.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now