mysql

brunomoss
(usa Fedora)

Enviado em 22/09/2009 - 15:29h

galera to com esse scrip aqui, e preciso fazer com que tenha a opcao de instalar em um servidor remoto caso necessario, alguem tem alguma ideia?

#!/usr/bin/expect -f

set force_conservative 0 ;# set to 1 to force conservative mode even if
;# script wasn't run conservatively originally
if {$force_conservative} {
set send_slow {1 .1}
proc send {ignore arg} {
sleep .1
exp_send -s -- $arg
}
}

set timeout 15
#set user [lindex $argv 0]
#set senha [lindex $argv 1]
#set host [lindex $argv 2]

#log_user 0
spawn mysql
match_max 100000
expect "mysql>"
send -- "create database scmunic;\r"
expect "mysql>"
send -- "use scmunic;\r"
expect "mysql>"
send -- "source scmunic.sql;\r"
expect "mysql>"
send -- "exit\r"
log_user 1
expect eof

brunomoss
(usa Fedora)

Enviado em 22/09/2009 - 16:39h

acho q consegui:


#!/usr/bin/expect -f

set force_conservative 0 ;# set to 1 to force conservative mode even if
;# script wasn't run conservatively originally
if {$force_conservative} {
set send_slow {1 .1}
proc send {ignore arg} {
sleep .1
exp_send -s -- $arg
}
}

set timeout 15
#set user [lindex $argv 0]
#set senha [lindex $argv 1]
#set host [lindex $argv 2]

#log_user 0
echo "Deseja criar a base de dados no mysql local? s/n";read SN
if [ "$SN" == "s" ];then
spawn mysql
match_max 100000
expect "mysql>"
send -- "mrs.sql;\r"
expect "mysql>"
send -- "exit\r"
log_user 1
expect eof
elif [ "$SN" == "n" ];then
mysql -u DBUSERNAME -h DBSERVER
spawn mysql
match_max 100000
expect "mysql>"
send -- "source mrs.sql;\r"
expect "mysql>"
send -- "exit\r"
log_user 1
expect eof
else
echo ""
echo "Opção não reconhecida, tente novamente"
fi
done