mysql>load data infile 'D:\post.txt' into table posts; 用工具导入很慢，所以用此方式导入。 1、ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv

修改C:\ProgramData\MySQL\MySQL Server 5.7\my.ini配置文件 找到“secure-file-priv”，将该行配置注释掉。 #secure-file-priv="C:/ProgramData/MySQL/MySQL Server 5.7/Uploads"

2、ERROR 29 (HY000): File 'D:\ProgramData\MySQL\Data\post.txt' not found (Errcode:2 - No such file or directory) 【解决办法】将D:\post.txt拷贝到 'D:\ProgramData\MySQL\Data\post.txt' 目录后执行。 如图：