MySQL LOAD DATA INFILE question

[Justec]

I'm using LOAD DATA LOCAL INFILE and for some reason it only imports half the data.

I tried doing 68254 rows of data and it did 34127.
I then tried doing 68256 of data and it did 34128.

If I use the replace option and run the query 2 times the second time will import all the data. Any idea? I'm guessing its a setting somewhere, but thought I would post this while I go and look around.

[Justec]

Changed:

LINES TERMINATED BY '\n'

to

LINES TERMINATED BY '\r\n'

and it works now

[Justec]

Thanks past Justin, was working on this now and forgot how I fixed it in my testing before.