Creating a Customized Mysql Docker Image Supported by Initialization Scripts

README.md

Creating a Customized Mysql Docker Image Supported by Initialization Scripts

Containerization has many advantages. One advantage among these is getting up and running quickly with a production ready datasource, which has predefined data in it. This way we can reuse the shared application data state in local development environments easily. The snippets above serves as a baseline to achieve this goal. Further information is available on my blog

create_tables.sql

CREATE TABLE card (
       id bigint(20) NOT NULL,
       back varchar(255) NOT NULL,
       front varchar(255) NOT NULL,
       hint varchar(255) DEFAULT NULL,
       PRIMARY KEY (id)
       );

Customized Mysql Docker Image

FROM mysql:8.0

LABEL description="My Custom Mysql Docker Image"

# Add a database
ENV MYSQL_DATABASE CARDS

#Check out docker entry point for further configuration :
# https://github.com/docker-library/mysql
COPY ./init-scripts/ /docker-entrypoint-initdb.d/

insert_data.sql

INSERT INTO card (id, front, back, hint) values (1, 'Front 1', 'Back 1', 'Hint 1');
INSERT INTO card (id, front, back, hint) values (2, 'Front 2', 'Back 2', 'Hint 2');
INSERT INTO card (id, front, back, hint) values (3, 'Front 3', 'Back 3', 'Hint 3');
INSERT INTO card (id, front, back, hint) values (4, 'Front 4', 'Back 4', 'Hint 4');
INSERT INTO card (id, front, back, hint) values (5, 'Front 5', 'Back 5', 'Hint 5');