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 }

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