Sha256: 55681badfb848d7fe3f66f398dd99eb5438b72ad6dc72e07e6ab06d0a8683291
Contents?: true
Size: 1000 Bytes
Versions: 17
Compression:
Stored size: 1000 Bytes
Contents
#!/bin/bash
USER="root"
PASSWORD="Password001"
HOST="127.0.0.1"
PORT="3306"
DBS=( cvty06feb cvtyc06feb edifiles06feb enroll06feb healthspan06feb hixenroll06feb starmount06feb summacare06feb tem06feb )
echo "********************************************************************************"
echo "Starting restore at:" `date`
START=`date +%s`
for DB in ${DBS[@]}; do
echo "--------------------------------------------------------------------------------"
echo "Starting to restore ${DB} at:" `date`
DBSTART=`date +%s`
mysql -u${USER} -p${PASSWORD} -h ${HOST} -P${PORT} < ${DB}.sql
DBEND=`date +%s`
echo "Finished restoring ${DB} at:" `date`
DIFF=`expr $DBEND - $DBSTART`
echo "Elapsed time:" ${DIFF}s
done
echo "--------------------------------------------------------------------------------"
END=`date +%s`
echo "Finished restore at:" `date`
DIFF=`expr $END - $START`
echo "Total time:" ${DIFF}s
echo "********************************************************************************"
Version data entries
17 entries across 17 versions & 1 rubygems