如何导入tsv数据文件到MySQL数据库，以及常见错误

{ 导入方法 }

LOAD DATA INFILE '/Users/boy.lee/Downloads/D Box/title.akas.tsv' INTO TABLE imdb_title;

{ ERROR }

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

编辑 my.cnf, 添加如下命令后重启MySQL服务即可

[mysqld_safe]
[mysqld]
secure_file_priv=""