同步数据库自动化脚本_MySQL

bitsCN.com

同步数据库自动化脚本

 

#!/bin/sh  www.bitsCN.com  

 

read -p "Please keyin your ssh host:" -t 30 host_ip

read -p "Please keyin your ssh user:" -t 30 username

read -p "Please keyin your ssh pass:" -t 30 password

read -p "Please keyin your sync table list,separated by spaces:" -t 30 table_list

 

datetime=`date +%Y%m%d%H%M%S`

src_file="/tmp/data_$datetime.sql"

tar_file="/tmp/data_$datetime.tar.gz"

 

mysqldump -h127.0.0.1 -uroot -ppass database_name $table_list > $src_file

tar czvf $tar_file $src_file

./expect_scp.sh $host_ip $username $password $tar_file

 

expect_scp.sh代码  www.bitsCN.com  

 

#!/tools/bin/expect

set timeout 10

set host [lindex $argv 0]

set username [lindex $argv 1]

set password [lindex $argv 2]

set src_file [lindex $argv 3]

#set dest_file [lindex $argv 4]

spawn scp $src_file $username@$host:/home/$username

 

expect {

"(yes/no)?"

{

send "yes/n"

expect "*assword:" { send "$password/n"}

}

"*assword:"

{

send "$password/n"

}

}

expect "100%"

expect eof

 

bitsCN.com