#!/bin/bash

stty -echo
printf 'MySQL ROOT Password: ' >&2
read PASSWORD
stty echo
printf "\n"

if [ -z "$PASSWORD" ]; then
  echo 'No password given!'
  exit 1
fi

MYSQL_ACCESS=" -uroot -p${PASSWORD} "

databases=`mysql $MYSQL_ACCESS --batch --skip-column-names -e "SHOW DATABASES;" | grep -E -v "(information|performance)_schema"`
date=`date +%Y%m%d`

for db in $databases; do
  echo "Dumping database: $db"
  mysqldump $MYSQL_ACCESS --databases $db | gzip > mysqldump--$db--$date.sql.gz
done