I'm trying to import a csv file into a mysql database using the import functionality of phpmyadmin. I've attached the csv file and a screenshot of the structure of the table. load-entities.csv
I always select "," for "Fields terminated by:" and blank for "Fields enclosed by:". I leave "Lines terminated by:" as "auto" but I'm not sure if this is correct since the most I can get is 1 line to be imported.
If I use "CSV" as the "Format of imported file" option, I get an error message:
"Invalid field count in CSV input on line 1."
If I use "CSV using Load Data" as the "Format of imported file" option, I get a message that the import is successful, but only 1 line of data is imported and the fields are screwed up.
I also tried removing the field (column) names from the import file and putting them in the "Column names" box in the import screen, but that didn't work either.
Any suggestions on how I can get this to work would be much appreciated.