#/bin/sh

#backup database everyday!

yday=`date -d yesterday +%Y%m%d`

mydump="/usr/local/service/mysql-3306/bin/mysqldump "

myuser="mydbbak"mypass="enbak"dirname="/root/myadmin"

hip=`ifconfig eth0 | grep "inet addr" | cut -d: -f2 | cut -d" " -f1`

hports=`netstat -lpn|grep mysqld|grep '^tcp'|awk '{print $4}'|awk -F":" '{print $2}'`

for tport in $hports

dotdirname="${dirname}/${yday}"mkdir -p $tdirnamebfilename="${tdirname}/${hip}:${tport}-${yday}.sql"echo "$bfilename"$mydump -u$myuser -p$mypwd -P$tport --all-databases --flush-logs --master-data=2 --single-transaction --quick >$bfilenamedone

exit

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/7916042/viewspace-1027721/，如需转载，请注明出处，否则将追究法律责任。