18 lines
481 B
Smarty
18 lines
481 B
Smarty
#!/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
|