#!/bin/shDBPATH=/server/backupMYUSER=rootMYPASS=oldboy123SOCKET=/data/3306/mysql.sockMYCMD="mysql -u$MYUSER -p$MYPASS -S $SOCKET"MYDUMP="mysqldump -u$MYUSER -p$MYPASS -S $SOCKET"[ ! -d $DBPATH ] && mkdir $DBPATHfor dbname in `$MYCMD -e "show databases;"|sed ‘1,2d‘|egrep -v "mysql|schema"`do $MYDUMP $dbname|gzip >$DBPATH/${dbname}_$(date +%F).sql.gzdone#!/bin/shDBPATH=/server/backupMYUSER=rootMYPASS=oldboy123SOCKET=/data/3306/mysql.sockMYCMD="mysql -u$MYUSER -p$MYPASS -S $SOCKET"MYDUMP="mysqldump -u$MYUSER -p$MYPASS -S $SOCKET"[ ! -d $DBPATH ] && mkdir -p $DBPATHfor dbname in `$MYCMD -e "show databases;"|sed ‘1,2d‘|egrep -v "mysql|schema"`do mkdir $DBPATH/${dbname}_$(date +%F) -p for table in `$MYCMD -e "show tables from $dbname;"|sed ‘1d‘` do $MYDUMP $dbname $table|gzip >$DBPATH/${dbname}_$(date +%F)/${dbname}_${table}.sql.gz donedone原文：http://www.cnblogs.com/shengy/p/7472797.html