1 files changed, 29 insertions, 0 deletions
diff --git a/scripts/Old/blow-away-databases.sh b/scripts/Old/blow-away-databases.sh
new file mode 100644
index 00000000..44df7861
--- /dev/null
+++ b/scripts/Old/blow-away-databases.sh
@@ -0,0 +1,29 @@
+#!/bin/sh -
+# $Id$
+
+# Copyright (C) 2007--2008  American Registry for Internet Numbers ("ARIN")
+#
+# Permission to use, copy, modify, and distribute this software for any
+# purpose with or without fee is hereby granted, provided that the above
+# copyright notice and this permission notice appear in all copies.
+#
+# THE SOFTWARE IS PROVIDED "AS IS" AND ARIN DISCLAIMS ALL WARRANTIES WITH
+# REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF MERCHANTABILITY
+# AND FITNESS.  IN NO EVENT SHALL ARIN BE LIABLE FOR ANY SPECIAL, DIRECT,
+# INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES WHATSOEVER RESULTING FROM
+# LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE
+# OR OTHER TORTIOUS ACTION, ARISING OUT OF OR IN CONNECTION WITH THE USE OR
+# PERFORMANCE OF THIS SOFTWARE.
+
+# GRANT ALL ON rpki.* TO rpki@localhost IDENTIFIED BY '<secret>';
+# GRANT ALL ON irdb.* TO irdb@localhost IDENTIFIED BY '<secret>';
+
+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-irdb.sql
+) |
+mysql -u root -p