Cannot import txt file on MySQL Server 8.0, because of secure_file_priv

Question

I have followed this reply, but still does not work...

I run: LOAD DATA INFILE 'C:\ProgramData\MySQL\MySQL Server 8.0\Uploads\Parts_with_eClass_Code.txt' INTO TABLE partnumbersclassified;

I get the following:

Error Code: 1290. The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

I have added the file in the standard Uploads folder here:

'secure_file_priv', 'C:\ProgramData\MySQL\MySQL Server 8.0\Uploads\'

Why does it not work?

Check if you have local_infile = 1. – vishal Mar 15 '19 at 12:58 — vishal, Mar 15 '19 at 12:58

score 0 · Accepted Answer · answered Mar 15 '19 at 12:49

Check your file path and replace "\" to "/". I solved my problem after replacing that...

LOAD DATA INFILE 'C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/Parts_with_eClass_Code.txt' INTO TABLE partnumbersclassified.

I wished they could given another error code for this type of errors...

1 Answers1