MySQL load data infile loading exactly half the records

Did you generate your csv file under Windows as well ? If yes, you might have to use LINES TERMINATED BY '\r\n'