创建shell脚本topjui_source.exp,内容如下:
#!/usr/bin/expect
spawn echo "###### running... ######"
spawn echo $argv0
spawn echo $argv1
set timeout 30
spawn mysql -uroot -p123456
set timeout 30
expect {
"hi" { send "You said hi\n"}
"hello" { send "Hello yourself\n"}
"bye" { send "That was unexpected\n"}
"mysql>" { send "use demo_topjui_com\r"}
}
expect {
#"mysql>" {send "source /home/backup/mysql/topjui/topjui.sql\r"}
}
expect "mysql>"
send "exit\r"
interact
加入到定时计划中,每5分钟自动还原一次topjui数据库:
*/5 * * * * /usr/bin/expect /home/shell/topjui_source.exp > /home/shell/log/topjui_source.log 2>&1
Linux下自动还原MySQL数据库的Shell脚本
标签:sql elf usr UI roo backup source sql数据库 rac
本条技术文章来源于互联网,如果无意侵犯您的权益请点击此处反馈版权投诉
本文系统来源:http://www.cnblogs.com/xvpindex/p/7263857.html