0

SELECT * INTO OUTFILE 'dataset.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '""' LINES TERMINATED BY '\n' FROM reviews.opinions;

ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

Abhishek Kumar
  • 77
  • 6
  • A little search with your error message quickly gets you there : https://stackoverflow.com/questions/32737478/how-should-i-tackle-secure-file-priv-in-mysql – Aurelien Apr 26 '18 at 18:25
  • this reference is for loading text file data into database table. But i am trying to write table data into csv file.. – Abhishek Kumar Apr 26 '18 at 20:07
  • The answer to your question is in the accepted answer of the reference. – Aurelien Apr 26 '18 at 21:52

0 Answers0