summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorEvan Prodromou <evan@controlyourself.ca>2008-09-22 15:58:24 -0400
committerEvan Prodromou <evan@controlyourself.ca>2008-09-22 15:58:24 -0400
commitd53b34e403ca62dbc7c515e94110db9b602f16a8 (patch)
tree28f1bd98af98df30b83bb72fb603590af71c6c84
parente24425d44ea6416f6d20add0e1e872fb23ff5214 (diff)
clear and rebuild db scripts
darcs-hash:20080922195824-5ed1f-f95ae048209e44e4de7698d98eb8a01121a2231d.gz
-rwxr-xr-xscripts/cleardb.sh11
-rwxr-xr-xscripts/rebuilddb.sh14
2 files changed, 25 insertions, 0 deletions
diff --git a/scripts/cleardb.sh b/scripts/cleardb.sh
new file mode 100755
index 000000000..06690ed70
--- /dev/null
+++ b/scripts/cleardb.sh
@@ -0,0 +1,11 @@
+#!/bin/bash
+
+export user=$1
+export password=$2
+export DB=$3
+export SCR=$4
+
+mysqladmin -u $user --password=$password -f drop $DB
+mysqladmin -u $user --password=$password create $DB
+mysql -u $user --password=$password $DB < $SCR
+
diff --git a/scripts/rebuilddb.sh b/scripts/rebuilddb.sh
new file mode 100755
index 000000000..89bc6e252
--- /dev/null
+++ b/scripts/rebuilddb.sh
@@ -0,0 +1,14 @@
+#!/bin/bash
+
+export user=$1
+export password=$2
+export DB=$3
+export SCR=$4
+
+mysqldump -u $user --password=$password -c -t --hex-blob $DB > /tmp/$DB.sql
+mysqladmin -u $user --password=$password -f drop $DB
+mysqladmin -u $user --password=$password create $DB
+mysql -u $user --password=$password $DB < $SCR
+mysql -u $user --password=$password $DB < /tmp/$DB.sql
+
+