mysql Long text and net packet limit

Posted on 2011-10-06
Last Modified: 2012-06-27
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?
Question by:ccMcBride
    LVL 24

    Accepted Solution

    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:

    Author Closing Comment

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

    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
    I have been using r1soft Continuous Data Protection ( for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now