I'm importing a csv using mysqlimport as seen below.
mysqlimport --local --user=root -p --fields-terminated-by=, --lines-terminated-by="\n"
--fields-enclosed-by="\"" --ignore-lines=1 --replace db c:/tblcsv.csv
This works fine on my dev machines (win 7/wamp 2.0).
Doing this on my server (2008) only imports the first record. So I went for --lines-terminated-by="\r\n" and "\\r\\n" but get still only get the first record.
ODDITIES AND NOTES
I noticed that after successfully importing on a dev machine, the last field in the records (which are blank in the csv) have " in them after importing.
The first field in the csv is blank. (autoinc when imported)