I have done my code to import US.txt in mysql and it works fine up to 2000 lines. When I try to import 2500+ lines, I get the following errors in the SQL UI:

error on MySQL UI

It doesn't come from a specific line (eg. line 2300) as I have also tried different combinations (eg. importing line 2000-4000).

Any idea where it could come from?

  • Can you please edit your question and post the import query and any surrounding loop code?
    – Cliff B
    Dec 12 '15 at 21:23

Assuming you get this error when viewing places table after import, check out this post: a problem with displaying the places table

  • mmh, you were right. It seems the problem was not the import, but the display of the data... I simply chosed sample of data to be displayed instead and it was fine. Thanks
    – david_d_ch
    Dec 14 '15 at 8:00

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .