從centos伺服器上將Database Backup拷貝到本地

從centos伺服器上將Database Backup拷貝到本地 centosubuntu指令碼備份資料庫解決此問題要用到expect指令碼：寫法如下，注意一定要設定timeout長一點，否則考到一半就停止了：#!/usr/bin/expect -fset password ********set date [exec date "+%Y%m%d"]#download local hostspawn scp -r root@{IP地址}:/home/{ps-name}/backup/db/production$date.sql /root/db/set timeout 3expect {"yes/no" {send "yes\r";exp_continue}}expect "root@{IP地址}'s password:"set timeout 30send "$password\r"set timeout 3000send "exit\r"expect eof