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
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?