codemonauts/mysql repository overview

⁠codemonauts/mysql

Simple MySQL 5.7 container with a few handy tools for local development:

• Import/Export script
• mycli⁠, as an alternative MySQL-client with nicer colors and better tab completion
• sqlstrip⁠ to reduce loading time of databas dumps

⁠Usage with docker-compose

services:
  db:
    image: codemonauts/mysql
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: topsecret
      MYSQL_DATABASE: foo
      MYSQL_USER: bar
      MYSQL_PASSWORD: baz
    volumes:
      - .:/data:delegated
      - db-data:/var/lib/mysql:delegated

volumes:
  db-data:

⁠Import

Place the dump into the same folder where your docker-compose.yml file is located, so the file is visible inside the container.

docker-compose exec db import databasedump.sql.gz

The dump can either be plain sql, or an compressed sql file (supported extensions are sql.gz, sql.zst and zip)

⁠Export

This will dump the database defined by '$MYSQL_DATABASE' into a gzipped file.

docker-compose exec db dump