Import SQL file Error

I have a csv file which i can import when choose ignore 0 lines. If i choose ignore first line, i get No rows were imported This can have several causes:

• File is empty
• Wrong file encoding was selected or detected
• Field and/or line terminator do not fit to the file contents i have attached a sql file to create the table and the csv file. (just updated to the latest supported version). Nothinmg odd about the options for the import. Not a big deal as i can easily work around it. thanks.

No problem here - 20 rows imported:

Only the table sql file contained rows with the same primary key value, so in the first run I got lots of warnings like this:

Warning: (1062) Duplicate entry 'additional_options' for key 'PRIMARY'

So I deleted all rows in the table and re-ran the import, which then worked nice.

What is the error on your side?

My BAD. somehow i had Fields Escaped by as ". When I remove that, i can import and skip first row. If have the double quote in Fields Escaped, i get the error but not for skip 0 lines and only for skip first 1 line. Sorry about not mentioning the truncate destination table. I kept fooling around with it and got tired of deleting the rows in the table.

Glad you could fix it!