MySQL import tsv data file
How to import tsv data file to MySQL database, and the error will show
{ Import Command }
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
edit my.cnf, add the follow command and restart the MySQL server
[mysqld_safe]
[mysqld]
secure_file_priv=""
Leave Comment