Bug #78866 Mysqlimport on command line doesnt import csv table

• Submitted: 17 Oct 2015 15:55
• Modified: 19 Oct 2015 6:24
• Reporter: Alan Jebakumar
• Status: Not a Bug
• Category: MySQL Server: Command-line Clients
• Severity: S3 (Non-critical)
• Version: 5.6
• OS: Windows
• CPU Architecture: Any

[17 Oct 2015 15:55] Alan Jebakumar

Description:
Team,

When i try to do the below operation, it fails-
H:\>mysqlimport.exe Events \\room.com\root-1\Reports\NamesList.csv -u root -h dcw01 -p --fields-enclosed-by='"' --ignores-lines=1 --lines-terminated-by='\r\n' --fields-terminated-by=','

I get the below-
Enter password: ********

mysqlimport.exe: Error: 1083, Field separator argument is not what is expected; check the manual,when using table: NamesList

Kindly advise how can this be fixed.

How to repeat:
NA

[19 Oct 2015 6:24] MySQL Verification Team

We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.

Please refer - https://dev.mysql.com/doc/refman/5.6/en/mysqlimport.html

[root@cluster-repo ~]# mysql -uroot test -e "show create table NameList\G"
*************************** 1. row ***************************
       Table: NameList
Create Table: CREATE TABLE `NameList` (
  `name` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1
[root@cluster-repo ~]#

[root@cluster-repo ~]# mysql -uroot test -e "truncate NameList"
[root@cluster-repo ~]# mysqlimport -uroot test --fields-enclosed-by='"' --lines-terminated-by='\n' /root/NameList.csv
test.NameList: Records: 9  Deleted: 0  Skipped: 0  Warnings: 0
[root@cluster-repo ~]# mysql -uroot test -e "select * from NameList"
+---------------------+
| name                |
+---------------------+
| Lael, Amaya         |
| Tyrone, Yoshio      |
| Ivor, Kuame         |
| Wing, Maryam        |
| Ayanna, Magee       |
| Amery, Nerea        |
| Zephr, Nerea        |
| Chiquita, Alexander |
| Rosalyn, Zenia      |
+---------------------+
[root@cluster-repo ~]# cat NameList.csv
"Lael, Amaya"
"Tyrone, Yoshio"
"Ivor, Kuame"
"Wing, Maryam"
"Ayanna, Magee"
"Amery, Nerea"
"Zephr, Nerea"
"Chiquita, Alexander"
"Rosalyn, Zenia"