revert mythdb-initial to a working state

1 files changed, 22 insertions, 14 deletions

diff --git a/abs/core-testing/mythtv/stable/mythdb-initial/mythdb.install b/abs/core-testing/mythtv/stable/mythdb-initial/mythdb.install
index 7833aa4..4834c69 100755
--- a/abs/core-testing/mythtv/stable/mythdb-initial/mythdb.install
+++ b/abs/core-testing/mythtv/stable/mythdb-initial/mythdb.install
@@ -1,23 +1,31 @@
 mydate=`date +%m-%d-%y`
 HOST=`hostname`
 post_install() {
-    echo archiving the old database
-    mysqldump mythconverg > /data/database/mythconverg.${mydate}.sql
+#echo backup the old database
+	mysqldump mythconverg   >/data/database/mythconverg.${mydate}.sql 
+#	echo dropping the old database
+	mysql -u root -e 'drop database mythconverg;' 
+        mysql -u root -e 'create database mythconverg;'  
+	echo installing the default database
+	if [  $HOST = 'larch5' ]
+	then
+           cp /data/database/mc.sql.initial /data/database/mc.sql.fixed
+	   cp /data/database/permissions.sql  /data/database/permissions.sql.fixed
+	else
+	    sed -e "s/larch5/$HOST/g" /data/database/mc.sql.initial > /data/database/mc.sql.fixed
+	    sed -e "s/larch5/$HOST/g" /data/database/permissions.sql > /data/database/permissions.sql.fixed
 
-    echo installing the baseline database
-    sed -e "s/MythTVhost/$HOST/g" /data/database/mc.sql.initial > /data/database/mc.sql.fixed
-    sed -e "s/MythTVhost/$HOST/g" /data/database/permissions.sql > /data/database/permissions.sql.fixed
-    mysql < /data/database/mc.sql.fixed 2>/dev/null
-    mysql < /data/database/permissions.sql.fixed 2>/dev/null
-    # Keep the baseline SQL file around because it's useful to learn what changes users made
-    # to their Tweaker-customized defaults.
-    #rm /data/database/mc.sql.initial
-}
+	fi
+		
+	mysql mythconverg < /data/database/mc.sql.fixed 2>/dev/null 
+	mysql < /data/database/permissions.sql.fixed 2>/dev/null 
 
+	rm /data/database/mc.sql.initial
+}
 post_upgrade() {
-    echo "nothing to do"
+	echo "nothing to do"
 }
 
-op=$1
-shift
+op=$1 
+shift 
 $op $*