MySQL --secure-file-priv

Asked Aug 12 '16 at 04:15

Active Aug 12 '16 at 04:15

Viewed 418 times

I am trying to import data from a txt file to MySQL using

LOAD DATA INFILE 'C:/path/to/file.txt' INTO TABLE tbl_name

However I am getting an error

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

I have done some searching but can't find anything specific to this error.

Any suggestions? Thanks

asked Aug 12 '16 at 04:15

puks1978

6

You tried [this](http://stackoverflow.com/q/32737478/2518525) or [this](http://stackoverflow.com/q/31951468/2518525) ? – Darren Aug 12 '16 at 04:21
Nope as I didn't find those links. Doing it now. Thanks – puks1978 Aug 12 '16 at 04:24
Beauty! No probs man :) – Darren Aug 12 '16 at 04:27

0 Answers0