backup all databases

mysql-all-backup.sh

#!/bin/bash

USER="root"
PASSWORD=""
OUTDIR="`basename $1`"

if [ -z "$OUTDIR" ]; then
  echo "Specify an output directory"
  exit 1;
fi

read -s -p "Password: " PASSWORD
echo "Ok"

if [ -z "$PASSWORD" ]; then
  echo "Specify a pasword."
  exit 2;
fi

databases=`mysql -u $USER -p$PASSWORD -s --skip-column-names -e "SHOW DATABASES;" | grep -Ev '(mysql|information_schema)'`

for db in $databases; do
  filename="$db--`date +%Y%m%d`"
  echo "Dumping database: $filename"
  mysqldump -u $USER -p$PASSWORD --databases $db | gzip > "${OUTDIR}/${filename}.sql.gz"
done