LOAD DATA LOCAL INFILE problem

Hi all, I am importing 2 csv files into MySQL via php using the "LOAD DATA LOCAL INFILE". the first file imports correctly but the second stops halfway?

First file: 5000 rows @ 2183kb
Second file: 31000 rows @ 2100kb.

As you can see the second file ha more rows but a smaller file so really miffed why this stops at 17,911 rows every time.

Any ideas... So weird?

have you looked at the row it stops at? could it be hitting something it doesnt like?