| 1 | #!/bin/bash |
|---|
| 2 | ########################################### |
|---|
| 3 | DATE_STR=2009-10-22-1308 # should match the form of: date +%Y-%m-%d |
|---|
| 4 | DBSET=a |
|---|
| 5 | ########################################### |
|---|
| 6 | |
|---|
| 7 | echo "Starting to restore the $DBSET with the dumps in $DATE_STR-cdm_edit_portals_$DBSET.tar.gz"; |
|---|
| 8 | read -p "MySQL User:" MYSQL_USER |
|---|
| 9 | read -s -p "MySQL Password:" pwd |
|---|
| 10 | tar -xzf $DATE_STR-cdm_edit_portals_$DBSET.tar.gz |
|---|
| 11 | |
|---|
| 12 | echo "restoring cdm_edit_cichorieae_$DBSET .."; |
|---|
| 13 | echo "DROP DATABASE cdm_edit_cichorieae_$DBSET; CREATE DATABASE cdm_edit_cichorieae_$DBSET;" | mysql -u $MYSQL_USER --password=$pwd |
|---|
| 14 | mysql -u $MYSQL_USER --password=$pwd cdm_edit_cichorieae_$DBSET < $DATE_STR-cdm_edit_cichorieae_$DBSET.sql |
|---|
| 15 | |
|---|
| 16 | echo "restoring cdm_edit_palmae_$DBSET .."; |
|---|
| 17 | echo "DROP DATABASE cdm_edit_palmae_$DBSET; CREATE DATABASE cdm_edit_palmae_$DBSET;" | mysql -u $MYSQL_USER --password=$pwd |
|---|
| 18 | mysql -u $MYSQL_USER --password=$pwd cdm_edit_palmae_$DBSET < $DATE_STR-cdm_edit_palmae_$DBSET.sql |
|---|
| 19 | |
|---|
| 20 | echo "restoring cdm_edit_diptera_$DBSET .."; |
|---|
| 21 | echo "DROP DATABASE cdm_edit_diptera_$DBSET; CREATE DATABASE cdm_edit_diptera_$DBSET;" | mysql -u $MYSQL_USER --password=$pwd |
|---|
| 22 | mysql -u $MYSQL_USER --password=$pwd cdm_edit_diptera_$DBSET < $DATE_STR-cdm_edit_diptera_$DBSET.sql |
|---|
| 23 | |
|---|
| 24 | |
|---|
| 25 | echo "deleting sql dumps ..."; |
|---|
| 26 | rm $DATE_STR-cdm_edit_*.sql |
|---|
| 27 | |
|---|
| 28 | echo "done!"; |
|---|
