# 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 duplicate entry error can probably be fixed by running myisamchk on the
table.
Hope this helps.
ryan
> 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 1062: Duplicate entry 'Chr1_A_thaliana' for key 1
>
> But, there is no entries in the table. Could you give me any suggestion?
>
> Thank you in advance.
>
> Wei Zhu
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php