I was trying to import a massive csv dataset into phpMyAdmin and it kept throwing error:
Invalid field count in csv input on line 1

This is quite annoying as I followed all the usual steps as per normal.

To solve this I had to do the following:

  • Import
  • Browse for your CSV file.
  • Select CSV using LOAD DATA (rather than just CSV)
  • Change “Fields terminated by” from “;” to “,”
  • Make sure “Use LOCAL keyword” is selected.
  • Click “Go”

Done!

Still having problems? Let me know..