phpMyAdmin – 1Invalid field count in csv input on line Published on April 9, 2010 by Andrew in CSV, error, phpMyAdmin 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 was very annoying as it was all being done the way it always works for me!
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!