mysqldump导出数据 The MySQL server is running with the --secure-file-priv option so it cannot execute

朴灿烈づ我的快乐病毒、 2023-02-09 14:22 10阅读 0赞

# Got error: 1290: The MySQL server is running with the --secure-file-priv option so it cannot execute this statement when executing 'SELECT INTO OUTFILE #

今天在使用`mysqldump`命令导出数据时，出现Got error: 1290: The MySQL server is running with the --secure-file-priv option so it cannot execute this statement when executing 'SELECT INTO OUTFILE’错误。  
如图：  
![在这里插入图片描述][20200519151431586.png]  
出现此错误原因是因为在使用`mysqldump`命令导出数据时如果加了`-T`参数，代表导出两份文件，一份是`.sql`，另一份是`.txt`文件。**而`-T`参数导出的数据文件必须是要在指定目录下才可以。**

*  查看当前mysql的默认导出路径：

mysql> select @@secure_file_priv;
    +-----------------------+
    | @@secure_file_priv    |
    +-----------------------+
    | /var/lib/mysql-files/ |
    +-----------------------+
    1 row in set (0.00 sec)
    
    mysql>

当前数据库导出的文件必须要在`/var/lib/mysql-files/`文件下才可以，否则就会出现刚刚的错误。

*  重新导出：

mysqldump -uroot -padmin -T /var/lib/mysql-files/ test userinfo

![在这里插入图片描述][20200519151611786.png]  
进入`/var/lib/mysql-files/`查看导出的文件：  
![在这里插入图片描述][20200519151705726.png]

**问题解决！**

[20200519151431586.png]: https://img-blog.csdnimg.cn/20200519151431586.png
[20200519151611786.png]: https://img-blog.csdnimg.cn/20200519151611786.png
[20200519151705726.png]: https://img-blog.csdnimg.cn/20200519151705726.png

mysqldump导出数据 The MySQL server is running with the --secure-file-priv option so it cannot execute

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 The MySQL server is running with the –read-only option so it cannot execute this statement

相关 MYSQL导出数据出现The MySQL server is running with the --secure-file-priv option so it cannot execute this

相关 Mysql 1290 - The MySQL server is running with the --secure-file-priv option

相关 mysqldump导出数据 The MySQL server is running with the --secure-file-priv option so it cannot execute

相关 mysql5.7导出数据报错The MySQL server is running with the --secure-file-priv option so it cannot execute

相关 The MySQL server is running with the --secure-file-priv option so it cannot execute 解决放法

相关 Linux：ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cann

相关 The MySQL server is running with the --read-only option so it cannot execute this statement

相关 mysql into outfile导出数据的时候出现错误： The MySQL server is running with the --secure-file-priv option so i

相关问题：The MySQL server is running with the--skip-grant-tables option