mysql database duplicate script
MYSQL_HOST1="host名"
MYSQL_HOST2="host名"
MYSQL_USERNAME1="ユーザー名"
MYSQL_USERNAME2="ユーザー名"
MYSQL_PASSWORD1="パスワード"
MYSQL_PASSWORD2="パスワード"
MYSQL_DATABASE="データベース名"
expect -c "
spawn bash -c \"mysqldump -h $MYSQL_HOST1 -u $MYSQL_USERNAME1 -p -B $MYSQL_DATABASE > dbdump.sql\"
expect \"Enter password:\"
send \"$MYSQL_PASSWORD1\n\"
expect \"$\"
exit 0
"
expect -c "
spawn bash -c \"mysql -h $MYSQL_HOST2 -u $MYSQL_USERNAME2 -p < dbdump.sql\"
expect \"Enter password:\"
send \"$MYSQL_PASSWORD2\n\"
expect \"$\"
exit 0
"
rm -rf dbdump.sql