I'm trying to load data to mysql from local using the below command
LOAD DATA INFILE "mnt/home/edureka_519340/Sqoop_Files.county_facts.csv" INTO TABLE county_data_sample
FIELDS TERMINATED BY "," ENCLOSED BY """
LINES TERMINATED BY "\r\n"
IGNORE 1 LINES;
But getting the following error
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement.
Please suggest how to load the mentioned csv file data in local path to the mysql table.
I am using Edureka Cloud Lab.