MySQL record limit

[Anon]

Hi, I'm trying to import a text file in to a single table. The text file has 1880 lines but when I import it in to MySQL through phpmyadmin it cuts off at 126 records. Is there a set record limit some place? I've also tried "load data local infile" but that only works if I have the text file in the same directory as the database (embarrassed beyond belief) I don't know where the database is on the server so I can't put the text file in the same directory.
Any help would be much appreciated.
thank you
Erik

[Anon]

your auto increment has something to do with it I saw this probelm before but can quite put my finger on it. But check the auto increment I think that has something to do with it

Hope that helps

[Anon]

Sweet!! At least you gave me something to look at 🙂
Thank you

Erik

[Anon]

The Id row make sure it is not TINY INT this can cause this problem too But if I find something else I'll let you know

[Anon]

Thanks Richie,
I found out that INT was the ticket for the Id row. The new list loaded fine...
thanks again for the help

Erik