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
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.