Bug #68846 how to create Bad file in LOAD DATA INFILE in mysql
Submitted: 3 Apr 2013 6:56 Modified: 3 Apr 2013 7:35
Reporter: esha sethi Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: DML Severity:S3 (Non-critical)
Version:Mysql server 5.1 OS:Any
Assigned to: CPU Architecture:Any

[3 Apr 2013 6:56] esha sethi 
Description:
Need to use LOAD DATA infile in mysql like sqlldr in oracle along with bad and log file in which to place all records that it could not load

How to repeat:
 used :sqlldr tata/tata control="D:\sale\abc.ctl" log="D:\sale\a.log", BAD="D:\sale\a.bad" in oracle
[3 Apr 2013 7:05] MySQL Verification Team 
Still looks like a duplicate of http://bugs.mysql.com/bug.php?id=11480
You can use sql_mode='strict_all_tables' so the import stops at the first error?
[3 Apr 2013 7:35] esha sethi 
Is there any way to create log file?