MySQL Docker: The MySQL server is running with the --secure-file-priv option so it cannot execute this statement

README.md

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

$ docker-compose exec service mysql -u root -p -e "SELECT @@global.secure_file_priv;"
Enter password:
+---------------------------+
| @@global.secure_file_priv |
+---------------------------+
| /var/lib/mysql-files/     |
+---------------------------+

$ docker cp /path/to/source/table.tsv $(docker-compose ps -q service):/var/lib/mysql-files/

$ docker-compose exec service mysqlimport -u root -p database /var/lib/mysql-files/table.tsv

Ref.

database - How should I tackle --secure-file-priv in MySQL? - Stack Overflow

• https://stackoverflow.com/questions/32737478/how-should-i-tackle-secure-file-priv-in-mysql

LOAD DATA INFILE solution · Issue #118 · docker-library/mysql

• docker-library/mysql#118