MySQL scripts in docker-entrypoint-initdb are not executed

by

You should clear data_volume before run the container and the sql files will be executed. This volume data_volume can be removed by using command: docker volume rm data_volume.

The root cause of your problem can be found in docker-entrypoint.sh. When you run a mysql container, it checks mysql directory /var/lib/mysql exist or not.
If the directory doesn’t exist (run it first time), it will run your SQL files.

    if [ ! -d "$DATADIR/mysql" ]; then
        //Some other logic here

        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 ;;
                *.sql.gz) echo "$0: running $f"; gunzip -c "$f" | "${mysql[@]}"; echo ;;
                *)        echo "$0: ignoring $f" ;;
            esac
            echo
        done

You can get more details at Dockerfile source

More Related Contents:

  1. Setting up MySQL and importing dump within Dockerfile
  2. How can I initialize a MySQL database with schema in a Docker container?
  3. Connect to mysql in a docker container from the host
  4. How to connect mysql workbench to running mysql inside docker?
  5. Docker-compose check if mysql connection is ready
  6. How do I know when my docker mysql container is up and mysql is ready for taking queries?
  7. Docker (Apple Silicon/M1 Preview) MySQL “no matching manifest for linux/arm64/v8 in the manifest list entries”
  8. MYSQL_ROOT_PASSWORD is set but getting “Access denied for user ‘root’@’localhost’ (using password: YES)” in docker container
  9. Commit data in a mysql container
  10. Communications link failure , Spring Boot + MySql +Docker + Hibernate
  11. Connect to Docker MySQL container from localhost?
  12. Node.js connect to MySQL Docker container ECONNREFUSED
  13. How to connect locally hosted MySQL database with the docker container
  14. Access to mysql container from other container
  15. connecting to a docker-compose mysql container denies access but docker running same image does not
  16. How to initialize mysql container when created on Kubernetes?
  17. django cannot connect mysql in docker-compose
  18. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  19. How to grant remote access permissions to mysql server for user?
  20. Generating a series of dates [duplicate]
  21. Why is the estimated rows count very different in phpmyadmin results?
  22. Slow query when using ORDER BY
  23. How to import XML file into MySQL database table using XML_LOAD(); function
  24. Matching all values in IN clause
  25. Having both a Created and Last Updated timestamp columns in MySQL 4.0
  26. How can I set a maximum number of rows in MySQL table?
  27. Which is faster — INSTR or LIKE?
  28. Remove duplicate rows leaving oldest row Only?
  29. Show constraints on tables command
  30. Remove special characters from a database field

Leave a Comment