docker-mysqldump-sshd

docker: openssh-server invoking mysqldump 💾 🐳

Create logical backups of mariadb and mysql databases via SSH.

Whenever a SSH client connects mysqldump will be executed.

Useful to fetch backups via rsnapshot. See rsnapshot.conf.example.

$ sudo docker run --rm \
    -p 2200:2200 \
    -v /some/path/authorized_keys:/home/dump/.ssh/authorized_keys:ro \
    -e MYSQLDUMP_ARGS='--host=dbhost --user=dbuser --password=dbpass --all-databases' \
    fphammerle/mysqldump-sshd
$ ssh -p 2200 -T dump@localhost
-- MariaDB dump 10.17  Distrib 10.4.10-MariaDB, for Linux (x86_64)
--
-- Host: database    Database: demo
-- ------------------------------------------------------
[…]

Git tags docker/* contain signed docker image digests: https://github.com/fphammerle/docker-mysqldump-sshd/tags

Docker Compose 🐙

1. git clone https://github.com/fphammerle/docker-mysqldump-sshd
2. cd docker-mysqldump-sshd
3. Adapt $MYSQLDUMP_ARGS in docker-compose.yml
4. docker-compose up --build
5. Add authorized_keys to docker volume mysqldumpsshd_authorized_keys.