MySQL backup docker

sudo apt install pbzip2

mysql-backup.sh

#!/bin/bash

PASS=rootSqlPass
ARCHIVE_PASS=archivePass

rm -rf /srv/backup/mysql/
mkdir -p /srv/backup/mysql/
cd /srv/backup/mysql/

DATE=$(date +%Y-%m-%d)

mysql='docker exec mysql mariadb '
mysqldump='docker exec mysql mariadb-dump '

for i in `$mysql -u root -p${PASS} -e'show databases;' 2>/dev/null | grep -v information_schema | grep -v Database | grep -v performance_schema `; do
    $mysqldump -u root -p${PASS} $i 2>/dev/null | pbzip2 -c | openssl enc -e -aes-256-cbc -pbkdf2 -k ${ARCHIVE_PASS} -out ${i}-${DATE}.sql.gz.enc
done

Распаковка

openssl enc -d -aes-256-cbc -pbkdf2 -in archive.sql.bz2.enc | pbzip2 -d -c > archive.sql