MySQL Backup

mysql_dump_all.sh

#!/bin/bash

for dbname in `echo SHOW DATABASES | mysql | grep -v Database`;
    do
    case $dbname in
        information_schema)
            continue ;;
        mysql)
            continue ;;
        performance_schema)
            continue ;;
        test)
            continue ;;
        sys)
            continue ;;
        *)
            echo "Dumping: $dbname"
            mysqldump --routines --hex-blob --skip-comments --complete-insert --lock-all-tables $dbname --result-file=$dbname.sql && gzip $dbname.sql ;;
    esac
done;