LOAD DATA INFILE '/root/tk_worker_latestjan17.csv' INTO TABLE tk_worker_temp FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 ROWS;
I got the following error:
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
Solution:
- Run this command
SHOW VARIABLES LIKE "secure_file_priv";
to show the configured directory. - Move the file to the directory specified by
secure-file-priv
Thank you