ERROR: phpMyAdmin – Invalid field count in csv input on line 1
The csv file was generated using Microsoft eXcel 2010. Fields are separated by < , > while php importer expects < ; >
Error while importing a csv file dataset into phpMyAdmin: “Invalid field count in csv input on line 1″
Don’t worry! phpMyAdmin is smart enough and is able to import your data from csv
How to fix it:
Use the settings below
Browse for your csv file.
Select CSV using LOAD DATA
Change “Fields terminated by” from “;” to “,”
Make sure “Use LOCAL keyword” is selected.