mysqldockermariadbdatabase-backups

Docker MariaDB/Mysql dump

How can i mysqldump from running container on https://hub.docker.com/_/mariadb/ ?

I cant find any useful documentation or data?

Any method for backup and restore database.

This is my my continaer run command :

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

Solution

  • If we assume you created the MariaDB server container this way:

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

    Then you access it from another client container:

    docker run -it --link some-mariadb:mysql \
   --rm mariadb:latest \
   sh -c 'exec maria-dump -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

    Note: the MySQL equivalent binary is called mysqldump

    Finally, you can use the docker exec command to shell into the container running the MariaDB/MySQL server and use the client tools there.

    There are lots more helpful usage tips in the MySQL and MariaDB official image pages.

    Updates to answer via Mr_Thorynque and Thomas.