Mysql

From annawiki
Revision as of 2018-06-11T20:12:23 by Tobiasco (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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