#!/bin/bash

dt=$(date "+%a")

for f in `mysql -u foo --password=bar -e "show databases" | grep -v Database `
do
 echo Dumping ${f}
 ff="bck_db_${f}_${dt}"
 mysqldump --quick --skip-opt --add-drop-table -u foo --password=bar  $f > db-backups/$ff
 echo Sleeping
 sleep 30
done

cd db-backups
gzip bck_*