Bug #68844 how to craete Bad file in LOAD DATA INFILE in mysql
Submitted: 3 Apr 2013 6:46 Modified: 3 Apr 2013 6:49
Reporter: esha sethi Email Updates:
Status: Duplicate Impact on me:
Category:MySQL Server Severity:S4 (Feature request)
Version:Mysql server 5.1 OS:Any
Assigned to: CPU Architecture:Any

[3 Apr 2013 6:46] esha sethi
Need to import data through load data infile with log and bad file like sqlldr in oracle to place all records that it could not load due to some error

How to repeat:
 used : sqlldr tata/tata control="D:\sale\abc.ctl" log="D:\sale\a.log", BAD="D:\sale\a.bad" in oracle 

Need to do the same in mysql
[3 Apr 2013 6:49] MySQL Verification Team
MySQL has no such option at the moment.  
But this is a duplicate of an existing feature request: