Question

mysql的导出数据库的自动化脚本中怎么实现免人工输入密码

Answer 1

同步数据库自动化脚本
　　#!/bin/sh
　　read -p "Please keyin your ssh host:" -t 30 host_ipread -p "Please keyin your ssh user:" -t 30 usernameread -p "Please keyin your ssh pass:" -t 30 passwordread -p "Please keyin your sync table list,separated by spaces:" -t 30 table_listdatetime=`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_filetar czvf $tar_file $src_file
　　./expect_scp.sh $host_ip $username $password $tar_fileexpect_scp.sh代码
　　#!/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/$usernameexpect {
　　"(yes/no)?"
　　{
　　send "yes\n"
　　expect "*assword:" { send "$password\n"}
　　}
　　"*assword:"
　　{
　　send "$password\n"
　　}
　　}
　　expect "100%"
　　expect eof