MySQL Import

[Ryan Abrahams]

I hope I have the right forum for this, but here goes.

I am trying to import data from a CSV file daily, but I am getting messages about skipped files. I have tried this:

mysqlimport -u XXXX -p"XXXXXXXX" -L --socket=/tmp/mysql5.sock --delete --fields-terminated-by='|' --debug='d:t:o,/home/XXXX/private/debug.log' XXXX_stock africa.csv

I still get the warnings about the skipped records on the stdout:
soss_stock.africa: Records: 173559 Deleted: 0 Skipped: 35009 Warnings: 41


But no debug.log in the /home/XXXX/private/ directory. I am not sure if debugging has been disabled by my host, or if perhaps I have the wrong syntax for the --debug option. I know it writes to /tmp by default, but my hosting company does not allow writing to /tmp for its shell users.



mysql Ver 14.12 Distrib 5.0.67, for redhat-linux-gnu (i686) using EditLine wrapper


If someone can confirm that my syntax is right (DOCs only suggest --debug='d:t:o,FILENAME', not if you can use a full path or not) then I can contact my host and find out if I can get debugging enabled.


Kind regards,
Ryan Abrahams