From cbe2050420a65349a5fcf1f4cce6e7c76490f881 Mon Sep 17 00:00:00 2001
From: eric <eric>
Date: Mon, 12 Jul 2004 22:12:42 +0000
Subject: started on the package submit script

---
 support/schema/reloadtestdb.sh | 23 +++++++++++++++++++++++
 1 file changed, 23 insertions(+)
 create mode 100755 support/schema/reloadtestdb.sh

(limited to 'support/schema/reloadtestdb.sh')

diff --git a/support/schema/reloadtestdb.sh b/support/schema/reloadtestdb.sh
new file mode 100755
index 00000000..53ddf867
--- /dev/null
+++ b/support/schema/reloadtestdb.sh
@@ -0,0 +1,23 @@
+#!/bin/sh
+
+mydir=`pwd`
+if [ `basename $mydir` != "schema" ]; then
+	echo "you must be in the aur/support/schema directory to run this script"
+	exit
+fi
+
+echo "dropping old database..."
+yes | mysqladmin -uaur -paur drop AUR
+
+echo "recreating database..."
+mysqladmin -uaur -paur create AUR
+
+echo "recreating tables..."
+mysql -uaur -paur AUR < ./aur-schema.sql
+
+echo "loading dummy-data..."
+bzcat ./dummy-data.sql.bz2 | mysql -uaur -paur AUR
+
+echo "done."
+exit
+
-- 
cgit v1.2.3-24-g4f1b