Docker with MariaDB

1. Downloading an MariaDB image

   docker search mariadb
   docker pull mariadb:10.4

2. Creating a Container with network

   docker network create -d bridge mynetwork
   docker run --name mariadb -e MYSQL_ROOT_PASSWORD=mypass -p 3306:3306 --network mynetwork -d docker.io/library/mariadb:10.4

3. Container DB dump

   dump

   docker exec <containerid> /usr/bin/mysqldump -B <schema-name> --routines -u root --password=pass.123 <schema-name> > yoursqlname.sql

   back

   cat yoursqlname.sql | docker exec -i <containerid> /usr/bin/mysql -u root --password=pass.123 test

4. Connect to your container using a local mysql shell client

   mysql -P 3306 --protocol=tcp -u root -p

參考

https://mariadb.com/kb/en/installing-and-using-mariadb-via-docker/

https://blackie1019.github.io/2018/11/13/MariaDB-MySQL-dump-SQL-for-Docker-Container/