mysqlimport -- Command line help

[Wynder]

Trying to import a CSV file into mysql with the mysqlimport command.... My records look like this:

{}234528374983{},{}MIGLIORE{},{}ELEANORE{},{}C{},{}[e-mail]{},{}302-555-1212{}

So, fields are encased by {} and terminated by commas.

Using the command:

mysqlimport -u user -p --fields-enclosed-by='{}' --fields-terminated-by=',' dbName LIST.csv

Gives this error:

mysqlimport: Error: Field separator argument is not what is expected. Check the manual, when using table: LIST

Any thoughts?

[csn]

From the docs:

If not empty, the FIELDS [OPTIONALLY] ENCLOSED BY and FIELDS ESCAPED BY values must be a single character. The FIELDS TERMINATED BY and LINES TERMINATED BY values may be more than one character.

So you'll need to replace/remove the {}'s.