ITPub博客

#!/bin/bashTARGET=/BACKUPexport DT=`date +"%Y%m%d_%H%M"`export DESTDIR=${TARGET}/`date +"%Y%m%d/mysql"`TMPNAME=_dump_sql_tmp_$$function Backup(){local SERVERSERVER=$1BASE="$SERVER"_${DT}CURDIR=`pwd`echo " ${SERVER} to ${BASE}: "DEST=${DESTDIR}/${SERVER}/${DT}mkdir -p ${DEST}cd ${DEST}# getting list of databases...echo "SHOW DATABASES;" | mysql -pPASSWORD -u USER -h ${SERVER} > ${TMPNAME}while read DBdoif [ $DB != "Database" ]; thenec