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