MySQL Bugs: #15983: ignoring of some lines in files while using load data infile

Bug #15983	ignoring of some lines in files while using load data infile
Submitted:	26 Dec 2005 11:43	Modified:	26 Jan 2006 12:37
Reporter:	Nasir Ahamed	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server	Severity:	S4 (Feature request)
Version:	4.0.23	OS:	Any (all)
Assigned to:		CPU Architecture:	Any

Description:
I have an application in which the router gets the data and stores in the file which i have to store in the database .
I have used load data infile command to store the data.
If the data has no errors then the command works well
But if the data is not there or an error message is posted by the router in between say 100th and 101th record  the data inserted is null.
But i have to omit that line and start loading the next line
I found a way to do this in oracle but not in mysql.

How to repeat:
I have an application in which the router gets the data and stores in the file which i have to store in the database .
I have used load data infile command to store the data.
If the data has no errors then the command works well
But if the data is not there or an error message is posted by the router in between say 100th and 101th record  the data inserted is null.
But i have to omit that line and start loading the next line
I found a way to do this in oracle but not in mysql.

Thank you for a problem report. Please, send the sample data you want ot load (with "bad" lines), and SHOWS CREATE TABLE results for the table you want them to be loaded too. I'll try to provide the LOAD DATA INFILE statement to load them. If it will be impossible, I'll mark this report as verified feature request.

Oracle's SQL*Loader is a powerful tool, by the way, not a simple statement...

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".