linux - 如何编写expect脚本自动导入mysql数据库

Question

我的脚本是这样的
test.sh

#!/usr/bin/expect

set password  root
spawn mysql -u root -p

expect "password:"
send "$password\r\n"
send "drop database blog_api;\r\n"
send "CREATE DATABASE `blog_api` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;\r\n"
send "exit;\r\n"
expect "Bye"
send "mysql -uroot blog_api < 2017-01-09-12:00:09.sql;\r\n"
expect "Enter password:"
send "$password\r\n"
interact

导出是没有问题的，但是导入的话没有效果，大神求教。。。

Answer 1

你腳本中已經設定了變數password的值，為什麼不直接用shell呢，直接執行指令mysql -uroot -p $password blog_api < 2017-01-09-12:00:09.sql或是寫成shell腳本不就可以導入了。

Answer 2

為啥非要用expect呢，這個指令命名可以直接用shell來寫的expect呢，这个命令命名可以直接用shell来写的

#!/usr/bin/env bash
mysql -uroot -p 'root' -e 'drop database if exists blog_api; CREATE DATABASE `blog_api` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;'
mysql -uroot -p 'root' blog_api < 2017-01-09-12:00:09.sql

如果非要用expect

#!/usr/bin/expect

set password 'root'

spawn mysql -uroot -p -e "drop database if exists blog_api; create database `blog_api` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;"
expect "password:"
send "$password\r"
expect eof

spawn mysql -uroot blog_api < 2017-01-09-12:00:09.sql;
expect "password:"
send "$password\r"
expect eof

如果要用expect的話，試試看下面這樣🎜 rrreee