Import data utilizing command line MYSQLIMPORT.. error 2?


#1

I’m trying to load data from a CSV to a database on my server. Here is the command I’m using and the error that keeps getting generated.

mysqlimport -L -hHOSTNAME --user=username -pPassword --ignore-lines=1 --fields-optionally-enclosed-by=""" --fields-terminated-by=, --lines-terminated-by="\r\n" DBNAME TABLENAME /home/direct/path/phrets/property_cnd.csv

mysqlimport: Error: 2, File ‘/home/direct/path/phrets/rets_property_cnd’ not found (Errcode: 2), when using table:TABLENAME

Any ideas?? The file is there… AND I’m using -L for the local infile as indicated by the knowledge base: http://blog.dreamhosters.com/kbase/index.cgi?area=2444
[hr]
So I got a little bit further.

I don’t know why, but if I navigate to the directory where property_cnd.csv sits and don’t put the full path, it seems to not give an error.

However, it doesn’t seem to import anything either. I hit “enter” in Putty and it just shows a > line, like it is still waiting for input or some other command. Any idea what this means?


#2

Well, I expected someone to know… guess it is time to submit a support ticket.