Cant load csv files in mysql/bitnami kubernetes pod

Keywords: MySQL - AWS - Technical issue - Other
Description:
I’m trying to insert csv files into bitnami/mysql helm chart and I’m getting following error:

ERROR 3948 (42000) at line 1: Loading local data is disabled; this must be enabled on both the client and server sides

here is my.cnf :

[mysqld]
local_infile=1

[client]
loose-local-infile=1

here is my CI/CD yaml file:

script:
    - helm repo add bitnami https://charts.bitnami.com/bitnami
    - helm repo update
    - helm upgrade mysql-db bitnami/mysql
      --install
      --version 7.1.0
      --set image.repository=mysql
      --set image.tag=8.0.22
      --namespace namepsace1
      --set db.user=mysql_user
      --set fullnameOverride=mysql123
      --set db.password=passwd
      --set root.password=root_passwd
      --set db.name=tech_db
      --set-file master.config=db/my.cnf 
      --set initdbScriptsConfigMap=mysql-db-schema

here is my bash script Im executing in running pod:

 mysql -u ${MYSQL_USER} --password=${MYSQL_PASSWORD} ${MYSQL_DATABASE} -h ${MYSQL_HOST}  -e "LOAD DATA LOCAL INFILE '/tmp/init_data/$file' INTO TABLE $table_name FIELDS TERMINATED BY ';' ENCLOSED BY '\"' IGNORE 1 LINES";

I dont understand why Im getting this error because I copied successfully my.cnf into opt/bitnami/mysql/conf folder.

Has anybody experience with it ?

Hi @maros.zeleny,

We helped with the helm chart in our GitHub repository, could you open the issue there?

https://github.com/bitnami/charts/issues

Regards,
Ibone.

Yes, I could create an issue there.