How to import my db dump into mariadb on start?

Question

I have a docker-compose.yml file like this

version: '2'

services:

  wordpress:
    image: wordpress
    ports:
      - 8080:80
    environment:
      WORDPRESS_DB_NAME: my_wp
      WORDPRESS_DB_USER: my_user
      WORDPRESS_DB_PASSWORD: my_pass
    volumes:
      - ./src:/var/www/html

  mysql:
    image: mariadb
    environment:
      MYSQL_ROOT_PASSWORD: my_pass
    volumes:
      - ./db:/etc/mysql

I can run my containsers using the command docker-compose up and it works fine, but shows the default wordpress site with empty db to setup. What I want is, I have a db dump file my_db.sql which I want to load into mariadb when its initializing. How can I do that? and where do I need to put my my_db.sql file to be picked by mariadb container?

Roman · Accepted Answer · 2016-11-25 00:45:29Z

1

You have 3 options:

Mount your .sql file to /docker-entrypoint-initdb.d/

version: '2'

services:

  wordpress:
    image: wordpress
    ports:
      - 8080:80
    environment:
      WORDPRESS_DB_NAME: my_wp
      WORDPRESS_DB_USER: my_user
      WORDPRESS_DB_PASSWORD: my_pass
    volumes:
      - ./src:/var/www/html

  mysql:
   image: mariadb
    environment:
      MYSQL_ROOT_PASSWORD: my_pass
    volumes:
      - ./db:/etc/mysql
      - ./my_db.sql:/docker-entrypoint-initdb.d/my_db.sql

Use build directive in your docker-compose file and point to a dockerfile with following content:
```
FROM mysql
COPY my_db.sql /docker-entrypoint-initdb.d
```
Create a dummy container, Mount /my/own/datadir:/var/lib/mysql, then restore the database manually using the docker exec, then you can use the host directory when ever you want that db in a container.

edited Nov 25, 2016 at 0:45

Roman

20.3k6 gold badges73 silver badges85 bronze badges

answered Nov 24, 2016 at 17:45

Farhad Farahi

40.3k9 gold badges81 silver badges74 bronze badges

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

2 Comments

coure2011 Over a year ago

how exactly I need to update my docker-compose.yml file?

Farhad Farahi Over a year ago

Added example to the answer.

Jonnix · Accepted Answer · 2016-11-24 17:43:31Z

0

Mount the folder with your sql files to /docker-entrypoint-initdb.d on the container in the volumes section of the db definitions. Any .sql (and .sql.gz) files will be automatically run in.

See the Initializing a fresh instance section of the docs for more info.

answered Nov 24, 2016 at 17:43

Jonnix

4,1671 gold badge33 silver badges31 bronze badges

Collectives™ on Stack Overflow

How to import my db dump into mariadb on start?

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related