MySQL Forums
Forum List  »  Newbie

Unable to do "Load Data Infile"
Posted by: nguyen duc
Date: October 21, 2016 10:14AM

Hi ,

I just downloaded and installed Mysql 5.7 Windows x64 on my Windows 7 PC

i am testing the Load Data feature on an existing table

load data infile 'tran_lim2_ap.csv' into table sakila.test

But i get the error "1290" , The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

I put my file in the directory pointed by this variable, and check its value with "show variables" but i always have this error. I haven't changed anything in my.ini file.

It is really annoying because i can't evaluate MySQL for my use. For me this security option is really uneeded.

The import wizard uses Insert row by row , so it is really very low ! Load data should be used instead

Options: ReplyQuote


Subject
Written By
Posted
Unable to do "Load Data Infile"
October 21, 2016 10:14AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.