root/deployment-scripts/03_resetdb.sh
| Revision 89, 313 bytes (checked in by 235, 2 years ago) |
|---|
| Line | |
|---|---|
| 1 | #!/bin/sh |
| 2 | source settings |
| 3 | echo "We are dropping the database... ====" |
| 4 | echo |
| 5 | |
| 6 | for i in `echo "show tables" | mysql $DB -u $DBUSER -p$DBPASS | grep -v Tables_in_`; |
| 7 | do |
| 8 | echo $i; echo "DROP TABLE $i"| mysql $DB -u $DBUSER -p$DBPASS |
| 9 | done |
| 10 | |
| 11 | echo "Creating the new database... ====" |
| 12 | echo |
| 13 | cd $CODE |
| 14 | expect $CGI/initdb.exp |
| 15 |
Note: See TracBrowser
for help on using the browser.
