Question 84207 in Docker Question posted in
The official documentation can be found here.

Create database on docker startup

I want to create mysql database on docker-compose startup from database.sql script. My database.sql script is on location: src/main/java/com/project_name/resources/db/database.sql. How should I wrote that in my docker-compose.yml file? Right now neither works.

    volumes:
    - ./database.sql:/data/application/database.sql

or something like:

        volumes:
    - ./database.sql:/src/main/java/com/project_name/resources/db/database.sql
Tags:

2

Answers


  1. 0

    Try like this:

        volumes:
      - ./src/main/java/com/project_name/resources/db/:/docker-entrypoint-initdb.d/database.sql

    Or just use a database migration tool like Flyway or Liquibase.

    Login or Signup to reply.
  2. 0

    You can mount the schema and data in Volumes as I demonstrated below, make sure the backup file have proper access permissions and verify the path in your machine.

    version: '3.8'
services:
  db:
    image: mysql:8.0
    restart: always
    environment:
      - MYSQL_DATABASE=DB_NAME
      - MYSQL_USER: DB_USER
      - MYSQL_ROOT_PASSWORD=DB_PASSEOD
    ports:
      - '3306:3306'
    volumes:
      - db:/var/lib/mysql
      - ./db/init.sql:/src/main/java/com/project_name/resources/db/database.sql
volumes:
  db:
    driver: local
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search