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 edit summary
 
Line 5: Line 5:
  mysqlimport: Error: 1290, The MySQL server is running with the --secure-file-priv option so it cannot execute this statement, when using table: exampletable
  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
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.

Latest revision as of 2018-06-11T20:13:29

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.