用脚本对mysql5.7 做xtrabackup的物理备份， 报错

周智林 发表于 2023-6-8 11:16
是个自编脚本吗?

这个有的，是个脚本  

[root@localhost bin]# pwd
/opt/xtrabackup/backup/bin
[root@localhost bin]# ll
total 16
-rwxr-xr-x. 1 root root 7415 Jun  2 16:42 backup.sh
-rwxr-xr-x. 1 root root  394 Jun 26  2021 expect_scp
-rw-r--r--. 1 root root 3704 Jun 25  2021 restore.sh

[root@localhost bin]# cat expect_scp
#!/usr/bin/expect -f
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@$hostdest_file
expect {
"(yes/no)?"
  {
    send "yes\n"
    expect "*assword:" { send "$password\n"}
  }
"*assword:"
  {
    send "$password\n"
  }
}
expect "100%"
expect eof