使用设置目录时，MySQL导出INTO OUTFILE --secure-file-priv错误 [英] MySQL exporting INTO OUTFILE --secure-file-priv error when using set directory

问题描述

我正在尝试在MySQL数据库上运行以下内容:

I'm trying to run the following on a MySQL database:

SELECT * FROM mysql.db
INTO OUTFILE "C:\ProgramData\MySQL\MySQL Server 5.7\Uploads\db.csv"
FIELDS TERMINATED BY '|'
ENCLOSED BY '"'
LINES TERMINATED BY '\n';

我得到了错误:

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

当我运行以下命令时:

mysql> SELECT @@secure_file_priv;

我得到:

+------------------------------------------------+
| @@secure_file_priv                             |
+------------------------------------------------+
| C:\ProgramData\MySQL\MySQL Server 5.7\Uploads\ |
+------------------------------------------------+

那么，即使我使用的是--secure-file-priv位置，为什么仍不导出文件?

So why is it not exporting the file even though I am using the set --secure-file-priv location?

我已经习惯了MSSQL和MySQL的新手.

I am used to MSSQL and new to MySQL.

推荐答案

Argh.这是一个怪胎的错字，我的\应该是/的

Argh. It was a freakin' typo, my \'s should have been /'s

所以我的查询现在是这样:

So my query is now this:

SELECT * FROM   mysql.db INTO OUTFILE "C:/ProgramData/MySQL/MySQL Server 5.7/Uploads/db_pipe.csv" FIELDS TERMINATED BY '|' ENCLOSED BY '"'  LINES TERMINATED BY '\n';

这篇关于使用设置目录时，MySQL导出INTO OUTFILE --secure-file-priv错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！