Hi,
Iam receiving some error during data loading. However, i would like to ignore those errors during data loading and continue to load rest of the data.
How could it be done?

Thanks.

I also has this problem, when I load datas as follows:

mysql—default-character-set=utf8 -ujyl -***  incrementbak -h****  -P 5029 -f -q—execute=“load data local infile ‘D:/docs/bak/ad_site_trace.sql’ replace into table ad_site_trace character set utf8 fields terminated by ‘\\t’ ENCLOSED BY ‘’  “

report an error : Wrong data or column definition. Row : 633823,field:5.

How can I ignore the error , and let the loading forward.

Any suggestion is welcome! Thanks a lot.

Hi tigerKing,

This error is quite common; it typically means either:
1) Row 633823 field 5 doesn’t fit the dimension specified in the DDL/Schema, or
2) There exists some erroneous character which is throwing off the import.  This is typically rectified by running “dos2unix” on the input file
3) The delimiter used (in this case, \\t or the enclosed by character) is present within the actual data (and is an inappropriate delimiter)

I’d first look at that row and field to ensure it fits the proper type.  Then, I’d recommend running dos2unix first on the data file.

As for ignoring the error,  I don’t believe you can within Infobright.  It’s all or nothing.  Someone will correct me if I’m wrong :-D

All the best,

Jeff

Note: tigerKing’s issue has been addressed within forum post http://www.infobright.org/Forums/viewthread/2401/.