Home Explore Help
Register Sign In
fphammerle
/
docker-mysqldump-sshd
mirror of https://github.com/fphammerle/docker-mysqldump-sshd
1
0
Fork 0
Files Issues 0 Wiki

No Description

Tree: 8093da022f
Branches Tags
docker-mysqldum...
ZIP TAR.GZ
Fabian Peter Hammerle 8093da022f upgrade alpine base image v3.12 -> v13.4 including openssh-server package upgrade v8.3_p1-r0 -> v8.4_p1-r3 & mariadb-client package upgrade v10.4.13-r0 -> v10.5.8-r0 (diff links below) 3 years ago
CHANGELOG.md 8bcb96f292 document changes since release v1.0.0 in changelog 3 years ago
Dockerfile 8093da022f upgrade alpine base image v3.12 -> v13.4 including openssh-server package upgrade v8.3_p1-r0 -> v8.4_p1-r3 & mariadb-client package upgrade v10.4.13-r0 -> v10.5.8-r0 (diff links below) 3 years ago
README.md 7fa57b083a readme: added link to signed docker image digests 4 years ago
docker-compose.yml b7a3fc6a2b docker-compose: added memory & cpu limit 3 years ago
entrypoint.sh 8cec374dcd init mysqldump-sshd from rsync-sshd repo 4 years ago
mariadb-client-package-log.url 8093da022f upgrade alpine base image v3.12 -> v13.4 including openssh-server package upgrade v8.3_p1-r0 -> v8.4_p1-r3 & mariadb-client package upgrade v10.4.13-r0 -> v10.5.8-r0 (diff links below) 3 years ago
openssh-package-log.url 8093da022f upgrade alpine base image v3.12 -> v13.4 including openssh-server package upgrade v8.3_p1-r0 -> v8.4_p1-r3 & mariadb-client package upgrade v10.4.13-r0 -> v10.5.8-r0 (diff links below) 3 years ago
rsnapshot.conf.example 8cec374dcd init mysqldump-sshd from rsync-sshd repo 4 years ago
sshd_config 8093da022f upgrade alpine base image v3.12 -> v13.4 including openssh-server package upgrade v8.3_p1-r0 -> v8.4_p1-r3 & mariadb-client package upgrade v10.4.13-r0 -> v10.5.8-r0 (diff links below) 3 years ago

README.md

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 2222:2222 \
    -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 2222 -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.