Mysql: Difference between revisions
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.