Back up all MariaDB/MySQL databases and optionally exclude certain dbs

backup-mariadb.sh

#!/bin/bash

# Set up variables
DBUSER=""
DBPASSWORD=""
DESTINATION="/volumes/external/mariadb"
EXCLUDE_DB="information_schema|performance_schema|mysql|sys"  # Add any databases you want to exclude

# Get the list of databases
DBS=$(mysql -u $DBUSER -p$DBPASSWORD -e "SHOW DATABASES;" | grep -Ev "Database|$EXCLUDE_DB")

# Dump each database
for DB in $DBS; do
    mysqldump -u $DBUSER -p$DBPASSWORD --databases $DB | gzip > $DESTINATION/$DB.sql.gz
done