Mysql: Difference between revisions

From annawiki
(Created page with "==mysqlimport== Misleading error message: mysqlimport -c viaf,isni --lines-terminated-by="\n" --fields-terminated-by=, --delete anna_all /home/example/exampletable.csv m...")
(No difference)

Revision as of 2018-06-11T21:12:23

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