Dump every databases on the server

dbbackup.sh

#!/bin/bash

USER="root"
PASSWORD="[yourpass]"

ExcludeDatabases="Database|information_schema|performance_schema|mysql"
databases=`mysql -u $USER -p$PASSWORD -e "SHOW DATABASES;" | tr -d "| " | egrep -v $ExcludeDatabases`

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