Friday, January 27, 2017

ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

I ran this command:

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:

  1. Run this command  SHOW VARIABLES LIKE "secure_file_priv"; to show the configured directory.
  2. Move the file to the directory specified by secure-file-priv 

Thank you

No comments:

Post a Comment