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@]来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7916042/viewspace-1027721/ ，如需转载，请注明出处，否则将追究法律责任。
