2019-11-25 15:23:26 0 Comments MySQL Boy.Lee

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 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