同步数据库自动化脚本
#!/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