Issue to laod csv file in Mysql


#1

Hi Team,

I’m try to load file a csv file in MYSQL with load inline command:

LOAD DATA INFILE '/Users/hachther/Documents/ID_BASE_20180319.csv'
	into table analytics.mtn_identification
    COLUMNS TERMINATED BY ','
    LINES TERMINATED BY '\n'
	IGNORE 1 LINES;

But I got this error:

The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

Someone have an idea?


#2

If you are import file from local drive use LOAD DATA LOCAL INFILE you will not have this error.