Hosting By EDS a Bob Johnson service. Website Hosing company logo(404)405-5442
MOBILE-OPTIMIZED hosting with BETTER SERVICE.
Hosting plans come with our
incredible LIFETIME PHONE and eMAIL SUPPORT.
Competitively priced with our website plans/Domain Name starting at only $29.95/year.
View our products
QUESTIONS, Please call me, 404-405-5442.

Client portal

Invalid field count in csv input on line 1

 August 2, 2011     0 Comments

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?

Powered by
  A Bob Johnson Computer Guy Company