LMSouq
server-admin Open

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

MA
Marcus Gomes
1 month ago
3 views
Problem Description
I am trying to create a container with a MySQL database and add a schema to these database. My current Dockerfile is: FROM mysql MAINTAINER (me) <email> # Copy the database schema to the /data directory COPY files/epcis_schema.sql /data/epcis_schema.sql # Change the working directory WORKDIR data CMD mysql -u $MYSQL_USER -p $MYSQL_PASSWORD $MYSQL_DATABASE < epcis_schema.sql In order to create the container I am following the documentation provided on Docker and executing this command: docker run --name ${CONTAINER_NAME} -e MYSQL_ROOT_PASSWORD=${DB_ROOT_PASSWORD} -e MYSQL_USER=${DB_USER} -e MYSQL_PASSWORD=${DB_USER_PASSWORD} -e MYSQL_DATABASE=${DB_NAME} -d mvpgomes/epcisdb But when I execute this command the Container is not created and in the Container status it is possible to see that the CMD was not executed successfully, in fact only the `mysql` command is executed. Anyway, is there a way to initialize the database with the schema or do I need to perform these operations manually?

AI-Generated Solution

Powered by LMSouq AI · GPT-4.1-mini

✓ Solution Ready
Analyzing problem and generating solution…
Was this solution helpful?
Back to Knowledge Base