mysql的一個備份指令碼

#/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
do
tdirname="${dirname}/${yday}"
mkdir -p $tdirname
bfilename="${tdirname}/${hip}:${tport}-${yday}.sql"
echo "$bfilename"
$mydump -u$myuser -p$mypwd -P$tport --all-databases --flush-logs --master-data=2 --single-transaction --quick >$bfilename
done

exit

[@more@]