Setting up MySQL and importing dump within Dockerfile

by

The latest version of the official mysql docker image allows you to import data on startup. Here is my docker-compose.yml 

data:
  build: docker/data/.
mysql:
  image: mysql
  ports:
    - "3307:3306"
  environment:
    MYSQL_ROOT_PASSWORD: 1234
  volumes:
    - ./docker/data:/docker-entrypoint-initdb.d
  volumes_from:
    - data

Here, I have my data-dump.sql under docker/data which is relative to the folder the docker-compose is running from. I am mounting that sql file into this directory /docker-entrypoint-initdb.d on the container.

If you are interested to see how this works, have a look at their docker-entrypoint.sh in GitHub. They have added this block to allow importing data

    echo
    for f in /docker-entrypoint-initdb.d/*; do
        case "$f" in
            *.sh)  echo "$0: running $f"; . "$f" ;;
            *.sql) echo "$0: running $f"; "${mysql[@]}" < "$f" && echo ;;
            *)     echo "$0: ignoring $f" ;;
        esac
        echo
    done

An additional note, if you want the data to be persisted even after the mysql container is stopped and removed, you need to have a separate data container as you see in the docker-compose.yml. The contents of the data container Dockerfile are very simple.

FROM n3ziniuka5/ubuntu-oracle-jdk:14.04-JDK8

VOLUME /var/lib/mysql

CMD ["true"]

The data container doesn’t even have to be in start state for persistence.

More Related Contents:

  1. How can I initialize a MySQL database with schema in a Docker container?
  2. Connect to mysql in a docker container from the host
  3. How to connect mysql workbench to running mysql inside docker?
  4. Docker-compose check if mysql connection is ready
  5. How do I know when my docker mysql container is up and mysql is ready for taking queries?
  6. Docker (Apple Silicon/M1 Preview) MySQL “no matching manifest for linux/arm64/v8 in the manifest list entries”
  7. MYSQL_ROOT_PASSWORD is set but getting “Access denied for user ‘root’@’localhost’ (using password: YES)” in docker container
  8. Commit data in a mysql container
  9. Communications link failure , Spring Boot + MySql +Docker + Hibernate
  10. Connect to Docker MySQL container from localhost?
  11. Node.js connect to MySQL Docker container ECONNREFUSED
  12. How to connect locally hosted MySQL database with the docker container
  13. Access to mysql container from other container
  14. connecting to a docker-compose mysql container denies access but docker running same image does not
  15. How to initialize mysql container when created on Kubernetes?
  16. django cannot connect mysql in docker-compose
  17. MySQL scripts in docker-entrypoint-initdb are not executed
  18. What’s the difference between utf8_general_ci and utf8_unicode_ci?
  19. Using union and order by clause in mysql
  20. mysql select from n last rows
  21. Install MySQL on Ubuntu without a password prompt
  22. Exporting results of a Mysql query to excel?
  23. use mysql SUM() in a WHERE clause
  24. A constraint to prevent the insert of an empty string in MySQL
  25. MySQL: Inner join vs Where [duplicate]
  26. Selecting from two tables with inner join and limit [duplicate]
  27. MySQL substring extraction using delimiter
  28. MySQL : retrieve a large select by chunks
  29. MySQL – insert data from another table merged with constants
  30. Default sort-ordering in MySQL (ALTER TABLE … ORDER BY …;)

Leave a Comment