Export All MySQL Databases

exportdbs.sh

#!/bin/bash

USER="root"
PASSWORD="root"

ExcludeDatabases="Database|information_schema|performance_schema|mysql|sys"
databases=`mysql -u$USER -p$PASWORD -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
done