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
• Status: Duplicate
• Category: MySQL Server
• Severity: S4 (Feature request)
• Version: Mysql server 5.1
• OS: Any
• CPU Architecture: Any

[3 Apr 2013 6:46] esha sethi

Description:
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:
http://bugs.mysql.com/bug.php?id=11480