diff options
| author | Rob Austein <sra@hactrn.net> | 2007-09-14 21:51:29 +0000 |
|---|---|---|
| committer | Rob Austein <sra@hactrn.net> | 2007-09-14 21:51:29 +0000 |
| commit | 4835dba39e444b0bf9b723d7214a0e13963eac81 (patch) | |
| tree | 1d76d2d63e322cda03c4812b893800089458c7b3 /scripts | |
| parent | 8ec96ec42e7f977a238a01187106635ffe87ffe4 (diff) | |
New tool
svn path=/scripts/blow-away-databases.sh; revision=960
Diffstat (limited to 'scripts')
| -rw-r--r-- | scripts/blow-away-databases.sh | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/scripts/blow-away-databases.sh b/scripts/blow-away-databases.sh new file mode 100644 index 00000000..7274a892 --- /dev/null +++ b/scripts/blow-away-databases.sh @@ -0,0 +1,12 @@ +#!/bin/sh - +# $Id$ + +echo "This script destroys and rebuilds our databases." +echo "Don't type the password unless you're sure you want to do this." + +(echo 'DROP DATABASE rpki; CREATE DATABASE rpki; USE rpki;' + cat ../docs/rpki-db-schema.sql + echo 'DROP DATABASE irdb; CREATE DATABASE irdb; USE irdb;' + cat ../docs/sample-irbe.sql +) | +mysql -u root -p |