Re: SELECT * INTO OUTFILE doe not work on Windows

[Wei Jiang]

Thank you for your reply.


I create c:\in and reset mysql, restart server:

mysql> SHOW VARIABLES LIKE "secure_file_priv";
+------------------+--------+
| Variable_name | Value |
+------------------+--------+
| secure_file_priv | c:\in\ |
+------------------+--------+
mysql> SELECT * INTO OUTFILE 'c:\in\tournament.csv'
-> FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '"'
-> LINES TERMINATED BY '\n'
-> FROM tournaments

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

D:\a\database>dir c:\in
Volume in drive C is OS
Volume Serial Number is E4A7-B3DF

Directory of c:\in

06/29/2021 08:17 AM <DIR> .
06/29/2021 08:17 AM <DIR> ..
0 File(s) 0 bytes
2 Dir(s) 58,939,117,568 bytes free

My mysql version:
Your MySQL connection id is 8
Server version: 8.0.21 MySQL Community Server - GPL

Anything wrong with my mysql version?