Daily mysql cron dumping all tables, except for information_schema. Writing backups to /var/backups/mysql.

mysql

#!/bin/sh
/usr/bin/find /var/backups/mysql/* -mtime +7 -exec rm {} \;
for DB in $(mysql -e 'show databases' -s --skip-column-names); do
    if [ "$DB" = "information_schema" ]
    then
        echo Skipping $DB
        continue
    fi
    echo -n Dumping $DB...
    /usr/bin/mysqldump --add-drop-database --add-drop-table --single-transaction --routines --triggers $DB | gzip > "/var/backups/mysql/$DB-$(date '+%Y%m%e').sql.gz";
    echo done
done