summaryrefslogtreecommitdiffstats
path: root/abs/core-testing/mythtv/old/stable-0.21/mythdb-initial/mythdb.install
diff options
context:
space:
mode:
authorCecil Hugh Watson <knoppmyth@gmail.com>2010-01-01 18:25:44 (GMT)
committerCecil Hugh Watson <knoppmyth@gmail.com>2010-01-01 18:25:44 (GMT)
commit6f5a7459a4127507c578cc22b8ae24550a45e123 (patch)
tree3aa68b61ad25846d919751959c7cd4e54ce2ce70 /abs/core-testing/mythtv/old/stable-0.21/mythdb-initial/mythdb.install
parent0b90a77e47c10ae4ba815122b0735bc74fba89ea (diff)
downloadlinhes_pkgbuild-6f5a7459a4127507c578cc22b8ae24550a45e123.zip
linhes_pkgbuild-6f5a7459a4127507c578cc22b8ae24550a45e123.tar.gz
linhes_pkgbuild-6f5a7459a4127507c578cc22b8ae24550a45e123.tar.bz2
Cleaning up the tree...
Diffstat (limited to 'abs/core-testing/mythtv/old/stable-0.21/mythdb-initial/mythdb.install')
-rwxr-xr-xabs/core-testing/mythtv/old/stable-0.21/mythdb-initial/mythdb.install31
1 files changed, 31 insertions, 0 deletions
diff --git a/abs/core-testing/mythtv/old/stable-0.21/mythdb-initial/mythdb.install b/abs/core-testing/mythtv/old/stable-0.21/mythdb-initial/mythdb.install
new file mode 100755
index 0000000..4834c69
--- /dev/null
+++ b/abs/core-testing/mythtv/old/stable-0.21/mythdb-initial/mythdb.install
@@ -0,0 +1,31 @@
+mydate=`date +%m-%d-%y`
+HOST=`hostname`
+post_install() {
+#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
+
+ 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"
+}
+
+op=$1
+shift
+$op $*