#!/bin/bash
# author: Eugenio Ghiglia <eugenio@blux.org>
#
DB=$(echo "show databases;" | mysql --user=root --password=[quipsw])
D=$(date +%a)
for I in $DB; do
        if [ $I != "Database" ]; then
                if [ $I != "information_schema" ]; then
                        mysqldump --user=root --password=[quipsw] $I > /backup/mysql/$I.$D.sql
                fi
        fi
done;
#
#
#