BACKUP_DIR=/home/backup/databases;
test -d "$BACKUP_DIR" || mkdir -p "$BACKUP_DIR"
# Get the database list, exclude information_schema
for db in $(mysql -B -s -u root --password="PASSWORD" -e 'show databases' | grep -v information_schema | grep -v mysql |grep -v performance_schema | grep -v sys )
do
  # dump each database in a separate file
mysqldump  "$db" > "$BACKUP_DIR/$db.sql"
done