I am running a local instance of
$ mysql --version mysql Ver 8.0.27-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu))
and would like to move the whole database into mariaDB docker container.
If I see it correctly I need two steps
- create data base
- deploying the docker container and integrating the data dump
I still struggle with creating a database dump and how to add into the container. Usually I use something like this as a compose file
version: '3.3' services: mariadb: container_name: my-mariadb ports: - '3306:3306' volumes: - '~/apps/mariadb/data:/var/lib/mysql' environment: - MYSQL_ROOT_PASSWORD=S3cret - MYSQL_PASSWORD=An0thrS3crt - MYSQL_USER=citizix_user - MYSQL_DATABASE=citizix_db image: 'mariadb:10.7'