mysql - 无法将 CSV 加载到 MySQL -(OS errno 13 - 权限被拒绝)

Question

问题

我想上传一个 .csv 文件到 MySQL Docker。
收到错误:找不到文件“xx.csv”(OS errno 13 - 权限被拒绝)

我的Dockerfile

FROM mysql:latest
ENV MYSQL_ROOT_PASSWORD password

COPY ./sql-scripts/ /docker-entrypoint-initdb.d/
COPY ./data /var/lib/mysql/
COPY my.cnf /etc/mysql/

EXPOSE 3306

我的.cnf

[mysqld]
pid-file    = /var/run/mysqld/mysqld.pid
socket      = /var/run/mysqld/mysqld.sock
datadir     = /var/lib/mysql


secure-file-priv = ""
local-infile = 1 
symbolic-links=0
!includedir /etc/mysql/conf.d/

我以 root 身份连接到 MySQL:

docker exec -it mysql_1 mysql -uroot -proot_password

然后执行SQL命令:

CREATE DATABASE data;
USE data;
CREATE TABLE IF NOT EXISTS `pregnant_mapping` (
    `label` varchar(255),
    `Pregnancy` varchar(255) PRIMARY KEY
);
LOAD DATA INFILE '/var/lib/mysql/pregnant_mapping.csv' INTO TABLE pregnant_mapping;

我尝试过的

试图在命令行中添加 LOCAL，但在我的 MySQL 版本中不起作用；得到错误:ERROR 1148 (42000): The used command is not allowed with this MySQL version

感谢您的帮助!

Answer 1

如果将 .csv 文件放在/var/lib/mysql 目录中，下面的语句应该有效

LOAD DATA INFILE '/var/lib/mysql/result' INTO TABLE mst_result FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';