Load CSV file data inot MySQL

Question

Hello,

I am trying to load csv file data into MySQL table using 

LOAD DATA INFILE "filename" INTO TABLE "tablename" FIELDS TERMINATED BY "," LINES TERMINATED BY "\n" IGNORE 1 ROWS 

in MySQL prompt but getting error 1290 saying that they MySQL server is running with the --secure-file-priv option so it cannot execute this statement.
 

Answer 1

If you are trying to load file from your system, you have to mention the keyword "local". Try this:

load data local infile "filename" INTO TABLE "tablename" FIELDS TERMINATED BY "," LINES TERMINATED BY "\n" IGNORE 1 ROWS