mysql备份与同步脚本

#!/bin/bash
#backup ad dbserver svr12232 to svr12234
#sip=192.168.4.154
cd /usr/local/yicha/tools/cnshop/backup/;

tables_list='table.list'
tb_list=`cat $tables_list|grep -v "#"`

echo `date +%F' '%T`' DB cntrade backup start........' >> cnshop_sys.log;

for TB_Name in $tb_list

do
/usr/local/mysql/bin/mysqldump -h 192.168.0.2 -uroot -proot --opt --compress cnshop $TB_Name | /usr/local/mysql/bin/mysql -uroot -proot  cnshop;
 echo `date +%F' '%T`" DB cntrade $TB_Name backup ok." >> cnshop_sys.log;
done

echo `date +%F' '%T`' DB cntrade backup finished!........' >> cnshop_sys.log;

#/bin/sh
lastday=`date --date="1 day ago" +%Y-%m-%d` ; #one day ago

if test $1
then
lastday=$1;
fi;

username="root";
password="root";
table="cnshop";
position="/usr/local/yicha/backup/db/";
filename=$table"."$lastday".sql";

/usr/local/mysql/bin/mysqldump -u$username -p$password --skip-opt  -R  $table >$position$filename;
#其中--skip-opt是去掉优化加锁能   -R是包括存储过程
cd $position;
tar czvf $filename".tgz" $