restore mysql dump file in many remote servers?

Shell Programming and Scripting
1

Hi all,
I want to restore DB file in many mysql servers, i already using script for sending the dumpfile in all servers, but it's just annoying if i have to restore the dumpfile in all servers, i want just execute 1 script, and will restore in all remote mysql servers. I make script but not working, im sure my logics it's not correct :confused:
Hope somebody can help me.

Thanks.

2

for anybody in this forum to help, you should have posted your script.

3

Im sorry. here is my script. Maybe somebody can help me, or have other way, thanks.

#!/bin/sh
export PATH=$PATH:/home/mysql/bin

jam=`date +%d%b%y`

mysqldump --database testdb -u root --password=password > /home/cabang/testdb-$jam.dmp
cd /home/cabang
tar zcfv jasper-$jam.tgz testdb-$jam.dmp

#Ftp for all branch
#MDN
ftp -n 192.168.4.25 <<!
quote user admin
quote pass password
bin
prompt
mput testdb-$jam.tgz
quit
#restore to mdn script
# Seems that this script wont work, coz, now im working in remote server
#just stop in ssh remote only
ssh 192.168.4.25
cd /home/admin
tar zxfv testdb-$jam.tgz
cd /home/mysql/mysql --database testdbmdn -u root --password < /home/admin/testdb-$jam.dmp
exit

#PLB
ftp -n 192.168.5.25 <<!
quote user admin
quote pass password
bin
prompt
mput testdb-$jam.tgz
quit
#restore to mdn script
# Seems that this script wont work, coz, now im working in remote server
ssh 192.168.4.25
cd /home/admin
tar zxfv testdb-$jam.tgz
cd /home/mysql/mysql --database testdbplb -u root --password < /home/admin/testdb-$jam.dmp
exit

......
......