How to import a database into a Docker container using docker-compose

Question

I am working with the official WordPress Docker image with docker-compose on my Mac (using boot2docker). I need to do a one-off data import. I'm not sure how to do this. How can I import data to the database container?

wordpress:
  image: wordpress
  links:
    - db:mysql
  ports:
    - 8080:80
  volumes:
    - .:/var/www/html/wp-content/themes/my-theme-name

db:
  image: mariadb
  environment:
    MYSQL_ROOT_PASSWORD: example

Duplicate stackoverflow.com/questions/25920029/… ?

Metal3d
– Metal3d

2015-11-27 16:14:43 +00:00
Commented Nov 27, 2015 at 16:14 — Metal3d
– Metal3d, Commented Nov 27, 2015 at 16:14

Lauri · Accepted Answer · 2015-06-04 05:49:56Z

28

When using official Wordpress image, default name of the created database is wordpress.

So after you have deployed Wordpress application with docker-compose, you can import your wordpress database by

docker exec -i db mysql -uroot -pexample wordpress < dump.sql

answered Jun 4, 2015 at 5:49

Lauri

4,7193 gold badges21 silver badges18 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:34:25Z

3

See this doc http://depressiverobot.com/2015/02/19/mysql-dump-docker.html and also this previous on SO Setting up MySQL and importing dump within Dockerfile

edited May 23, 2017 at 12:34

CommunityBot

11 silver badge

answered Jun 3, 2015 at 8:34

user2915097

32.4k6 gold badges61 silver badges62 bronze badges

2 Comments

Andrew Over a year ago

Yes, I've seen those and cannot get them to work. I don't think they work in this instance (also considering running with docker-compose/boot2docker). Can you please provide an example command to run?

user2915097 Over a year ago

Can you provide details about "and cannot get them to work"? Error messages and so. Installating Mysql and then launching a docker exec -i dump mysql -uroot -proot < dump.sql looks reasonable.

waspinator · Accepted Answer · 2019-01-21 02:55:43Z

1

copy your .sql or .sql.gz files into the mysql's /docker-entrypoint-initdb.d directory. It will automatically import the data into your database.

https://hub.docker.com/_/mysql

answered Jan 21, 2019 at 2:55

waspinator

6,90611 gold badges57 silver badges80 bronze badges

Collectives™ on Stack Overflow

How to import a database into a Docker container using docker-compose

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related