Sam Evans <[EMAIL PROTECTED]> wrote: > > I am attempting to insert into my table a huge block of text (talking > almost a megabyte). It seems like maybe a quarter of the way through it > just cuts off with no errors to my import script. > > I've changed my max_allowed_packet to 20M as well as my > net_buffer_length to 8M in my my.cnf file. > > Seems like no matter what I set these two values to, nothing helps. My > Column is set to LONGTEXT, but I cannot seem to find anywhere that would > set the size of the Longtext, and, according to the MySQL documentation > -- it seems as if the size of this column is dependant upon your max > allowed packet and buffer size?
Maximum size of data that you can store in the column depends on column type, size of the data that you can send from client to server depends on max_allowed_packet value. In the 3.23.xx version maximum size of max_allowed_packet is 16M. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
