Importing CSV to MySQL (docker-compose)

kirilljablonscky · December 12, 2021, 1:28pm

In order to import CSV to MySQL, you need to enable the global variable SET GLOBAL local_infile=1. If you do this via SQL Shell, then everything works fine.

But I need to make this setting set automatically when starting the docker container. To do this, I added the --local-infile=1 command to docker-compose at .wappler\targets\Development\docker-compose.yml, but it doesn’t work.

Tell me, please, what could be the problem?

bpj · December 12, 2021, 2:20pm

I think you have a - rather than _ in the command.

kirilljablonscky · December 12, 2021, 4:08pm

Unfortunately, the advice didn’t help.

Maybe I can edit my.cnf like in this tip?

kirilljablonscky · December 13, 2021, 3:46pm

Is it possible to use a server action to execute a command in the console?

sid · December 14, 2021, 11:18am

Custom extensions can be built to do that.

kirilljablonscky · December 14, 2021, 4:33pm

Thank you all. I managed to solve the problem. It turns out that after changing docker-compose, it is necessary not just to save the project and restart Wappler, but to do deploy.