diff options
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 |