#!/bin/sh
  
set -eo pipefail

HOME=/secrets
DEST=/backup

export ZSTD_CLEVEL=[[ .mariadb.backup.dumps.compression ]]
export ZSTD_NBTHREADS=0

echo Removing previous dumps
rm -f ${DEST}/*.sql.zst

for DB in $(mysqlshow | awk '{print $2}' | grep -v Databases | grep -v -E '^(information_schema)$'); do
  echo "Dumping ${DB} to ${DEST}/${DB}.sql.zst"
  mysqldump --ignore-table=mysql.event --single-transaction --add-drop-table $DB | zstd --no-progress -o ${DEST}/${DB}.sql.zst
done