locked
Unable to import csv file by mysql import tool RRS feed

  • Question

  • Geeks,

    First of all, sorry that im posting a MySQL query here, as I didn't find any answers for my query& hope that TechNet will find a solution for me.

    Imtrying to import a csv file using the MySQLImport tool, but it returns me this odd error-

    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=','

    This is what i get on its execution-

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

    Kindly suggest on how to fix this.


    Cheers, Alan.

    • Moved by Kalman Toth Saturday, October 17, 2015 5:07 PM Off topic
    Saturday, October 17, 2015 4:33 PM

All replies

  • Are you sure file you're trying to import has consistent delimiters? Error message looks like its an issue with delimiters. Can you check it first?

    Please Mark This As Answer if it solved your issue
    Please Vote This As Helpful if it helps to solve your issue
    Visakh
    ----------------------------
    My Wiki User Page
    My MSDN Page
    My Personal Blog
    My Facebook Page

    Saturday, October 17, 2015 4:38 PM
  • Hey Vis,

    I've checked it. Im trying to import a csv file like this-

    Names
    "Lael, Amaya"
    "Tyrone, Yoshio"
    "Ivor, Kuame"
    "Wing, Maryam"
    "Ayanna, Magee"
    "Amery, Nerea"
    "Zephr, Nerea"
    "Chiquita, Alexander"
    "Rosalyn, Zenia"

    Kindly suggest on fixing this.


    Cheers, Alan.

    Sunday, October 18, 2015 4:20 PM