Executing SQL scripts on docker container

Question

I have a docker container running mysql and I want to push a .sql file to the container and then have mysql execute the commands in it. The first step is fairly straightforward:

docker cp ./dummy.sql <container_id>:/

From there I am trying to run mysql from the command line and point it to the file that I just pushed to the container.

docker exec <container_id> mysql -u root -ppassword < /dummy.sql

This command appears to be trying to use /sample.sql as stdin locally rather than on the container. I also tried wrapping quotes around everything after the container ID which also seems to not work.

I also tried pushing a .sh file with the command in it to the docker container and then just executing that, but that is less ideal and also not working. Any advice?

Thomasleveil · Accepted Answer · 2017-06-20 12:25:37Z

43

If you are going to do pipe redirections in your command, pass it as a string to /bin/sh:

docker exec <container_id> /bin/sh -c 'mysql -u root -ppassword </dummy.sql'

edited Jun 20, 2017 at 12:25

answered Jan 14, 2016 at 13:45

Thomasleveil

105k18 gold badges123 silver badges119 bronze badges

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

Comments

PuzzledVacuum · Accepted Answer · 2021-05-11 14:09:48Z

37

One does not need to copy the script first. If the script is on the host then:

docker exec -i <container_name> mysql -u root -ppassword <mydb> < /path/to/script.sql

Or if the Use db directive is contained inside the script:

docker exec -i <container_name> mysql -u root -ppassword < /path/to/script.sql

edited May 11, 2021 at 14:09

answered Jun 14, 2018 at 6:18

PuzzledVacuum

5234 silver badges9 bronze badges

1 Comment

Keenan Over a year ago

You don't need to use -e or cat. You can simply use docker exec -i <container_name> mysql -u root -ppassword < /path/to/script.sql, assuming that the script is on the host.

Andrey · Accepted Answer · 2016-01-14 01:05:48Z

1

Try:

docker exec <container_id> 'mysql -u root -ppassword </dummy.sql'

answered Jan 14, 2016 at 1:05

Andrey

60.3k12 gold badges127 silver badges169 bronze badges

2 Comments

Akron Over a year ago

I mentioned trying that except I used double quotes rather than single. I'll try single quotes when I can. When I did that, it seems like docker was trying to execute the entire string as one literal command for some reason.

Andrey Over a year ago

@Akron if there are no quotes, bash will interpret string first (and pass dummy to stdio) before calling docker.

zemil · Accepted Answer · 2025-02-11 13:37:13Z

0

For local sql script use:

docker exec -i <container_name> mysql -u root -p root --database=your_db < ./local/script.sql

For simple sql within terminal use (with no -u -p shortcuts):

docker exec -i <container_name> mysql --user=root --password=root -e "show databases;""

answered Feb 11 at 13:37

zemil

5,2663 gold badges45 silver badges44 bronze badges

Collectives™ on Stack Overflow

Executing SQL scripts on docker container

4 Answers 4

Comments

1 Comment

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related