executing mysql script docker

Question

I have a mysql docker container and it is up and running. I can get into it and see the mysql prompt. I do not want to mount external storage on it. Everytime I start this container, I want to execute a test.sql script from my file system to create DB and do few such actions. When I run the script which exists in my current working directory, it complaints. I know this is trivial but I am unable to catch the issue.

/microservices/mysqlcontainer]docker exec 3a21e5e3669d /bin/sh -c 'mysql -u root -ppwd <./test.sql' /bin/sh: ./test.sql: No such file or directory

Is test.sql inside the image/container? docker exec 3a21e5e3669d ls -l test.sql — BMitch
– BMitch, Commented Jan 30, 2017 at 21:28
no it is outside and i also guess it could be the problem but some forums suggested this syntax as working. I have been able to connect to this container and get mysql prompt easily though like this docker exec -it mysqltest mysql -u root -ppwd — curiousengineer
– curiousengineer, Commented Jan 30, 2017 at 22:06

BMitch · Accepted Answer · 2017-01-30 22:39:08Z

5

Since your script is outside the container, there's no need to catch the shell input redirection. You should be able to run the following:

docker exec -i 3a21e5e3669d mysql -u root -ppwd <./test.sql

edited Jan 30, 2017 at 22:39

answered Jan 30, 2017 at 22:13

BMitch

271k51 gold badges555 silver badges511 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

curiousengineer Over a year ago

thanks, i do understand the linux concepts of redirection, pipes, stdout, etc. However, could you elaborate a little bit more on "no need to catch...". Your suggestion did work btw.

BMitch Over a year ago

The /bin/sh -c ' mysql .... <input.txt' is used to run the redirect inside the container's shell, sending the input to the mysql command. Without quotes, that redirect gets picked up by your shell and input is sent to the docker command which gets sent to the command you're running inside of docker when you have the -i flag (updating my questions now since I forgot that flag).

curiousengineer Over a year ago

thank you! Have been trying to docker-ize my microservices that i am prototyping using spring boot+netflix libraries. This helps. I needed sql container to hold authentication info for json web tokens. I can move ahead now as my auth service can talk to the DB and everytime i boot up the mysql container, the db is created with the script. I will probably read on my own how to mount an external file sys but that is not a priority for me right now

Collectives™ on Stack Overflow

executing mysql script docker

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related