From 4835dba39e444b0bf9b723d7214a0e13963eac81 Mon Sep 17 00:00:00 2001
From: Rob Austein <sra@hactrn.net>
Date: Fri, 14 Sep 2007 21:51:29 +0000
Subject: New tool

svn path=/scripts/blow-away-databases.sh; revision=960
---
 scripts/blow-away-databases.sh | 12 ++++++++++++
 1 file changed, 12 insertions(+)
 create mode 100644 scripts/blow-away-databases.sh

(limited to 'scripts')

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
-- 
cgit v1.2.3