backup-mysql.sh

#!/bin/sh

BACKUPDIR="/usr/backup/databases"
TODAY=$(date '+%Y-%m-%d')
DATABASES=$(echo "show databases;" | mysql)

mkdir -p "${BACKUPDIR}/${TODAY}"

for DB in $DATABASES; do
    if [ "$DB" != "Database" ] && \
       [ "$DB" != "mysql" ] && \
       [ "$DB" != "information_schema" ] && \
       [ "$DB" != "performance_schema" ]  && \
       [ "$DB" != "test" ]; then

       ## echo "db: $DB"
       mysqldump --databases "$DB" | xz > "${BACKUPDIR}/${TODAY}/${TODAY}_${DB}.sql.xz"
    fi
done