SQL：ERROR 1290 (HY000) ERROR 29 (HY000)

• ERROR 1290 (HY000): The MySQL server is running with the –secure-file-priv option so it cannot execute this statement.

执行MYSQL数据库数据导出遇见
因MYSQL对数据导出目录有限制
安装MYSQL后会生成配置文件my.ini，记录了MYSQL所有默认配置，在C盘ProgramData中找
1.mysql>show variables like '%secure%';#查看secure-file-priv的当前值
2.电脑本机中关闭SQL服务
3.打开my.ini文件，找到secure-file-priv这项，注释掉原先设置，设secure-file-priv=""，保存
4.启动SQL服务
5.此时再步骤1中语句，可知secure-file-priv默认值为空

• ERROR 29 (HY000): File ‘XXXX’ not found (OS errno 13 - Permission denied)

#显示MYSQL数据库存储目录
mysql>show variables where variable_name="datadir";