#!/bin/sh
mkdir -p /backup/mysql/
rm -fr /backup/mysql/*.gz
find /usr/local/mysql/data/ -type d > /backup/mysql/dbs.list
cat /backup/mysql/dbs.list |cut -d '/' -f 5 |xargs -iFILE echo mysqldump FILE \> /backup/mysql/FILE.sql \; > /backup/mysql/mkdump.sh
sh /backup/mysql/mkdump.sh
find /backup/mysql/ -name *.sql  -print |xargs gzip