SamMacy/docker-mysql-init

Initialize mysql database with a one-time command.

docker-mysql-init

Overview

This Dockerfile is a wrapper over the MySQL Command-Line Tool.

This Dockerfile is similar to senzing/mysql, but differs in the following ways:

1. The command is only run once. A "Sentinel File" is created on the first run. It prevents future runs. The file should be located on an external volume. Default location: /opt/senzing/mysql-init.sentinel.
2. On the first run, the command loops until it succeeds. This is useful in docker-compose formations where the mysql command needs to wait for mysql server to come up. An example is at senzing/docker-compose-mysql-demo.

Contents

1. Create Docker container
2. Run Docker container

Create docker container

docker build --tag senzing/mysql-init https://github.com/senzing/docker-mysql-init.git

Run Docker container

1. Identify the file of SQL to be run. Example: If the actual file pathname is /path/to/mysqlfile.sql

   export MYSQL_DIR=/path/to
   export MYSQL_FILE=mysqlfile.sql

2. Identify the database username and password. Example:

   export MYSQL_USERNAME=root
   export MYSQL_PASSWORD=root

3. Identify the database that is the target of the SQL statements. Example:

   export MYSQL_DATABASE=mydatabase

4. Identify the host running mySQL servers. Example:

   docker ps
   
   # Choose value from NAMES column of docker ps
   export MYSQL_HOST=docker-container-name

5. Identify the Docker network of the mySQL database. Example:

   docker network ls
   
   # Choose value from NAME column of docker network ls
   export MYSQL_NETWORK=nameofthe_network

6. Identify where the "sentinel file" should be located. The file should be on an external volume. Example:

   export SENZING_SENTINEL_FILE="${MYSQL_DIR}/mysql-init.sentinel"

7. Create the docker container. Note: parameters after senzing/mysql-init are mysql CLI options.

   docker run -it  \
     --volume ${MYSQL_DIR}:/sql \
     --net ${MYSQL_NETWORK} \
     --env SENZING_SENTINEL_FILE=${SENZING_SENTINEL_FILE} \
     senzing/mysql-init \
       --user=${MYSQL_USERNAME} \
       --password=${MYSQL_PASSWORD} \
       --host=${MYSQL_HOST} \
       --database=${MYSQL_DATABASE} \
       --execute="source /sql/${MYSQL_FILE}"