Dump all database on MySQL/MariaDB systems.

backup-all-databases-mysql.sh

#!/bin/bash

BACKUP_DIR="/opt/backup"
mkdir -p ${BACKUP_DIR}
## Get all databases on system
USER="root"
PASSWORD=""
DBS=`mysql -u ${USER} -p${PASSWORD} -sNe "SHOW DATABASES;" | grep -Ev "information_schema|performance_schema|mysql|test"`

for DB in ${DBS}
do
	TIMESTAMP=$(date +%Y%m%d)
	DBNAME="${DB}-$TIMESTAMP"
	mysqldump -u $USER -p$PASSWORD --events --routines --triggers --databases ${DB} | gz > "${BACKUP_DIR}/${DBNAME}.sql.gz"
done