#!/bin/bash

# Define backup path
BACKUP_DIR="/home/sql_backup"
mkdir -p "$BACKUP_DIR"

# Using
MYSQL_USER="root"

# list db, skip system file
DB_LIST=$(mysql -u$MYSQL_USER -e "SHOW DATABASES;" | grep -Ev "^(Database|information_schema|performance_schema|mysql|sys)$")

# export each db to SQL
for DB in $DB_LIST; do
    echo "Backing up: $DB"
    mysqldump -u$MYSQL_USER --databases "$DB" > "$BACKUP_DIR/${DB}_$(date +%F).sql"
done

echo "Backup done"