#! /bin/bash

DBPATH=/server/backupMYUSER=rootMYPASS=rootMYCMD="mysql -u$MYUSER -p$MYPASS"MYDUMP="mysqldump -u$MYUSER -p$MYPASS"[ -d "$DBPATH" ] && mkdir $DBPATHfor dbname in $MYCMD -e "show databases;"| sed '1,2d'|egrep -v "mysql|schema";domkdir $DBPATH/${dbname}$(date +%F) -p

for table in $MYCMD -e "show tables from $dbname";do

$MYDUMP $dbname $table|gzip >$DBPATH/$(dbname)$(date +%F)/${dbname}_${table}.sql.gzdonedone