Docker MariaDB / Mysql Dump

Question

How can I mysqldump run the container on https://hub.docker.com/_/mariadb/ ?

Can't find any useful documentation or data?

Any method for backing up and restoring a database.

This is my command to run my statement:

docker run --name myaapp-mariadb -v /databases/maria:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=password -d mariadb:10

Answer 1

If we assume that you created the mariadb server container as follows:

docker run --name some-mariadb -e MYSQL_ROOT_PASSWORD=my-secret-pw -d mariadb:latest

Then you will access it from another client container:

docker run -it --link some-mariadb:mysql \
   --rm mariadb:latest \
   sh -c 'exec mysqldump -h"$MYSQL_PORT_3306_TCP_ADDR" -P"$MYSQL_PORT_3306_TCP_PORT" -uroot -p"$MYSQL_ENV_MYSQL_ROOT_PASSWORD" database_name' > database_name_dump.sql

The official mysql image has more useful usage advice.