Re: SELECT * INTO OUTFILE doe not work on Windows

[Peter Brawley]

Quote

mysql> SHOW VARIABLES LIKE "secure_file_priv";
+------------------+-------+
| Variable_name | Value |
+------------------+-------+
| secure_file_priv | NULL |
+------------------+-------+

The default setting.

Quote

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

You've set it to D:\mysql_secure_file_priv\, is there such a folder?

For example, on this laltop, the [mysqld] section of my.ini has this setting ...

secure_file_priv="c:/in"

... I can import from and export to that folder.