解决MySQL导入导出时报错:
ERROR 1290 (HY000), The MySQL server is running with the –secure-file-priv option so it cannot execute this statement
首先 查看secure-file-priv
show variables like ‘%secure%’
这里显示了上传文件的路径必须是存于:
C:\ProgramData\MySQL\MySQL Server 5.7\Uploads\
文件夹下面
解决方法最好是:
将上传文件存于C:/ProgramData/MySQL/MySQL Server 5.7/Uploads/下面
执行语句相应的修改为:
load data infile ‘C:/ProgramData/MySQL/MySQL Server 5.7/Uploads/inportfilename.txt’ into table tablename fields terminated by’,’ lines terminated by’\r\n’;
这里需要非常注意的地方:
文件路径用”/ ”
即 C:/ProgramData/MySQL/MySQL Server 5.7/Uploads/inportfilename.txt
而不是
C:\ProgramData\MySQL\MySQL Server 5.7\Uploads\inportfilename.txt