Invalid field count in csv input on line 1

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!

Written by: andrewodendaal.com

How helpful was this article to you?