MySQL Database Setup

Once you have your MySQL database dump - the file should be current.zip - you're ready to setup your local database.

Steps to Install MySQL and Import Your Data

1. Extract the contents of current.zip to a location available to your Docker or Portainer setup
2. For example, persistent local storage for Docker is at \.docker so I'll create \.docker\clu\gcd-data\current.sql
3. Rename the extracted file to current.sql
4. the date formatted naming should import, but this makes it consistent for all users
5. Create a new Docker container using the below docker-compose settings

version: "3.8"

services:
    mysql:
      image: mysql:9.0
      container_name: mysql-gcd
      networks:
        - gcd-network
      environment:
        MYSQL_ROOT_PASSWORD: strong-root-password
        MYSQL_DATABASE: gcd_data
        MYSQL_USER: clu
        MYSQL_PASSWORD: strong-user-password
      volumes:
        - mysql_data:/var/lib/mysql
        - \YOU-UNZIPPED-MYSQL-FILE-LOCATION\current.sql:/docker-entrypoint-initdb.d/01-current.sql:ro
        - \YOU-UNZIPPED-MYSQL-FILE-LOCATION:/app/gcd-data:ro
      ports:
        - "3306:3306"

volumes:
    mysql_data:

networks:
    gcd-network:
      external: true

When you start the container for the first time:

• MySQL v9 will be installed
• the database will be created and the data from current.sql will be imported
• Length of the import will be dependent on the download size and the speed of your machine.
• Initial import should take around 60-minutes.

Once the DB is setup, you'll update your CLU docker-compose to use the same network and connect to the local GCD database.