How to loada 28MB LONGTEXT data?

2001-04-12 Thread Wei Zhu
Hi everyone; I have some problem in load a 28 MB LONGTEXT data into mysql database using "LOAD DATA INFILE ...". At the beginning, server returns me the error message as below: ERROR 1030: Got error 139 from table handler I tried the same command again, then I got another error message: ERROR

Re: How to loada 28MB LONGTEXT data?

2001-04-12 Thread ryc
# perror 139 Error code 139: Unknown error: 19 139 = Too big row (= 16 M) This means the 28MB row you tried loading is bigger than the max allowed packet size. You might want to change the max_allowed_packet variable (ie -O max_allowed_packet=32M or something similar on the commandline). The