dump-all-mysql-db.sh

#!/bin/bash

# Optional variables for a backup script
MYSQL_USER="root"
MYSQL_PASS="secret"
BACKUP_DIR=./$(date +%Y-%m-%d_%H%M%S);
test -d "$BACKUP_DIR" || mkdir -p "$BACKUP_DIR"

# Get the database list
for db in $(mysql -B -s -u $MYSQL_USER --password=$MYSQL_PASS -e 'show databases')
do

  case "$db" in
    performance_schema|mysql|information_schema)
      # ignore some databases
      echo "-> IGNORED DB: $db"
      continue
      ;;

    *)
      # dump each database in a separate file
      echo "processing: $db ..."
      mysqldump -u $MYSQL_USER --password=$MYSQL_PASS "$db" | gzip > "$BACKUP_DIR/$db.sql.gz"
      ;;
  esac

done