Ι am trying to import a csv file into an existing
mysql 5.7 table.
Here is the command (the db is in docker with bind mount for persistence)
mysql -h 127.0.0.1 -uroot -prootpass --local_infile=1 jira_statistics -e "LOAD DATA LOCAL INFILE '/home/centos/bugs.csv' INTO TABLE bugs FIELDS TERMINATED BY ','"
mysql> select * from bugs; Empty set (0.05 sec)
No error in the command line nor the
docker logs of mysql container.
What is more, the exit code of the
mysql command is