Mysql LOAD DATA INFILE 100,000 csv records perfect BUT 300,000 records - 0 rows inserted
Files checked with hex editor and answer revealed.

My CSVs differed in that rows either terminated with:


  Hex 0D CARRIAGE RETURN (\r), or
  
  Hex 0D CARRIAGE RETURN (\r) AND 0A LINE FEED (\n)


This is the line of code:

LINES TERMINATED BY '\r\n'


or

LINES TERMINATED BY '\r'


In my case, taking out the \n took care of it - either CSV imports perfectly.

If this line does not match the CSV, you get the silent treatment.  The SQL import will run without error yet no rows will import.