Backup Databases to Individual ZIPs

backup_mysqld.sh

#!/bin/bash

mysqlUser=""
mysqlPass=""
backup="/home/username/mysqldump"

databases=( $(mysql -u"$mysqlUser" -p"$mysqlPass" --skip-column-names --batch -e "show databases;" 2>"$temp") );
echo "found ${#databases[@]} databases.";

for i in ${databases[@]}; do
        if [ $i != "information_schema" ] && [ $i != "mysql" ] && [ $i != "phpmyadmin" ]; then
                echo -ne "Backing up database $i ... "
                mysqldump -u"$mysqlUser" -p"$mysqlPass" --opt $i | bzip2 -c > "$backup/$i.sql.bz2"
                echo "Done."
        fi
done

echo "Database backups complete."