#!/bin/bash
command=(
"mysql -u 'user' '-ppassword' -h 'rds-host01.com' 'database01' < 'sample.sql'"
"mysql -u 'user' '-ppassword' -h 'rds-host02.com' 'database02' < 'sample.sql'"
"mysql -u 'user' '-ppassword' -h 'rds-host01.com' 'database03' < 'sample.sql'"
"mysql -u 'user' '-ppassword' -h 'rds-host02.com' 'database04' < 'sample.sql'"
"mysql -u 'user' '-ppassword' -h 'rds-host01.com' 'database05' < 'sample.sql'"
)
for i in "${command[@]}"
do
eval ${i}
rc=$?
if [ $rc -ne 0 ]; then
echo "error =======> ######## $i ###########"
exit 1
fi
done
echo ""
echo "########## success ##########"
echo ""