How can I initialize a MySQL database with schema in a Docker container?

by

I had this same issue where I wanted to initialize my MySQL Docker instance’s schema, but I ran into difficulty getting this working after doing some Googling and following others’ examples. Here’s how I solved it.

1) Dump your MySQL schema to a file.

mysqldump -h <your_mysql_host> -u <user_name> -p --no-data <schema_name> > schema.sql

2) Use the ADD command to add your schema file to the /docker-entrypoint-initdb.d directory in the Docker container. The docker-entrypoint.sh file will run any files in this directory ending with ".sql" against the MySQL database.

Dockerfile:

FROM mysql:5.7.15

MAINTAINER me

ENV MYSQL_DATABASE=<schema_name> \
    MYSQL_ROOT_PASSWORD=<password>

ADD schema.sql /docker-entrypoint-initdb.d

EXPOSE 3306

3) Start up the Docker MySQL instance.

docker-compose build
docker-compose up

Thanks to Setting up MySQL and importing dump within Dockerfile for clueing me in on the docker-entrypoint.sh and the fact that it runs both SQL and shell scripts!

More Related Contents:

  1. Setting up MySQL and importing dump within Dockerfile
  2. How to store arrays in MySQL?
  3. Difference Between Schema / Database in MySQL
  4. Connect to mysql in a docker container from the host
  5. How to see indexes for a database or table in MySQL?
  6. Entity-Attribute-Value Table Design
  7. How to connect mysql workbench to running mysql inside docker?
  8. Docker-compose check if mysql connection is ready
  9. How do I know when my docker mysql container is up and mysql is ready for taking queries?
  10. Docker (Apple Silicon/M1 Preview) MySQL “no matching manifest for linux/arm64/v8 in the manifest list entries”
  11. MYSQL_ROOT_PASSWORD is set but getting “Access denied for user ‘root’@’localhost’ (using password: YES)” in docker container
  12. How to get all columns’ names for all the tables in MySQL?
  13. Commit data in a mysql container
  14. How do I show the schema of a table in a MySQL database?
  15. Is there an SQLite equivalent to MySQL’s DESCRIBE [table]?
  16. When to use MyISAM and InnoDB? [duplicate]
  17. Communications link failure , Spring Boot + MySql +Docker + Hibernate
  18. Connect to Docker MySQL container from localhost?
  19. Node.js connect to MySQL Docker container ECONNREFUSED
  20. How to connect locally hosted MySQL database with the docker container
  21. Access to mysql container from other container
  22. connecting to a docker-compose mysql container denies access but docker running same image does not
  23. How to initialize mysql container when created on Kubernetes?
  24. django cannot connect mysql in docker-compose
  25. MySQL scripts in docker-entrypoint-initdb are not executed
  26. Comparison of full text search engine – Lucene, Sphinx, Postgresql, MySQL? [closed]
  27. MySQL Error 1153 – Got a packet bigger than ‘max_allowed_packet’ bytes
  28. How to swap values of two rows in MySQL without violating unique constraint?
  29. Delete all rows with timestamp older than x days
  30. In what order are MySQL JOINs evaluated?

Leave a Comment