Bug #2742 fields-escaped-by only allows single character separator!
Submitted: 12 Feb 2004 5:25 Modified: 28 Feb 2007 22:24
Reporter: Are you mortal Then prepare to die. Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:mysqlimport Ver 2.8 OS:Any (3.23.58 RH linux gnu i386)
Assigned to: Assigned Account CPU Architecture:Any

[12 Feb 2004 5:25] Are you mortal Then prepare to die.

mysqlimport --fields-escaped-by='\t\|\t' ncbi_taxonomy ../division.dmp

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

Sadly this unusual field separator is in use by the NCBI in some of their flat file dumps. 

mysqlimport doesn't allow any field separator with more than a single character, which is a silly restriction really.

How to repeat:
See above

Suggested fix:
Allow multi character field separator, like the record separator!
[25 Dec 2006 10:18] Sveta Smirnova
Thank you for the report.

But problem is not field separator which can be any value, but incorrect error message which names field escape symbol "field separator"