Re: SELECT * INTO OUTFILE doe not work on Windows

[Wei Jiang]

Yes. Each time I restarted mysql server:
mysql> SHOW VARIABLES LIKE "secure_file_priv";
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| secure_file_priv | NULL |
+------------------+-------+

+------------------+----------------------------+
| Variable_name | Value |
+------------------+----------------------------+
| secure_file_priv | D:\mysql_secure_file_priv\ |
+------------------+----------------------------+

I still get the error:
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option


mysql works on Ubuntu. Strange.