Mysql

mysqlimport

Misleading error message:

mysqlimport -c viaf,isni  --lines-terminated-by="\n" --fields-terminated-by=, --delete  anna_all /home/example/exampletable.csv

mysqlimport: Error: 1290, The MySQL server is running with the --secure-file-priv option so it cannot execute this statement, when using table: exampletable

Reason for the error was that the file was not at /home/example/exampletable.csv, command worked fine after changing the path to the file name.