sinso/mariadb repository overview

⁠Docker MariaDB

⁠DB export

You can create database dumps with the db_dump command. There are no credentials necessary to run this command. And you can add custom parameters (e.g. --no-data)

• Output dump on STDOUT

  docker exec <DOCKER-CONTAINER-NAME> db_dump
  

  Copy

• Output dump on STDOUT (with custom parameters)

  docker exec <DOCKER-CONTAINER-NAME> db_dump --no-data
  

  Copy

• Save dump in file

  docker exec <DOCKER-CONTAINER-NAME> db_dump > `date +%Y%m%d`.sql
  

  Copy

• Save dump in compressed file

  docker exec <DOCKER-CONTAINER-NAME> db_dump | gzip -9 > `date +%Y%m%d`.sql.gz
  

  Copy

• Execute a fast dump (nice and without locking tables). There's the risk to get a inconsistent dump.

  docker exec <DOCKER-CONTAINER-NAME> db_fast_dump
  

  Copy

⁠DB import

To import a database use the following commands

• Import from a sql-file

  docker exec -i <DOCKER-CONTAINER-NAME> db_import < dump.sql
  

  Copy

• Import from another db container

  docker exec <SOURCE-DOCKER-CONTAINER-NAME> db_dump | docker exec -i <TARGET-DOCKER-CONTAINER-NAME> db_import
  

  Copy

• ... or even piped through ssh to a remote server

  Copy

` docker exec db_dump | ssh user@server "docker exec -i db_import"