summaryrefslogtreecommitdiffstats
path: root/support/schema/reloadtestdb.sh
diff options
context:
space:
mode:
Diffstat (limited to 'support/schema/reloadtestdb.sh')
-rwxr-xr-xsupport/schema/reloadtestdb.sh23
1 files changed, 23 insertions, 0 deletions
diff --git a/support/schema/reloadtestdb.sh b/support/schema/reloadtestdb.sh
new file mode 100755
index 0000000..53ddf86
--- /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
+