summaryrefslogtreecommitdiffstats
path: root/abs/core-testing/mythdb-initial/mythdb.install
diff options
context:
space:
mode:
authorCecil Hugh Watson <knoppmyth@gmail.com>2010-01-23 09:52:38 (GMT)
committerCecil Hugh Watson <knoppmyth@gmail.com>2010-01-23 09:52:38 (GMT)
commit332702fe9eaf2db10c7bc2fdf840460e9c119623 (patch)
treecdb7e4f3c0f61f7c2d1b278abb47ca952703e2cf /abs/core-testing/mythdb-initial/mythdb.install
parent2cb896aaa2e7143dacb9fcee9952fc572dbff3a7 (diff)
downloadlinhes_pkgbuild-332702fe9eaf2db10c7bc2fdf840460e9c119623.zip
linhes_pkgbuild-332702fe9eaf2db10c7bc2fdf840460e9c119623.tar.gz
linhes_pkgbuild-332702fe9eaf2db10c7bc2fdf840460e9c119623.tar.bz2
mythvantage for 0.22, latest mythtv
Diffstat (limited to 'abs/core-testing/mythdb-initial/mythdb.install')
-rwxr-xr-xabs/core-testing/mythdb-initial/mythdb.install31
1 files changed, 31 insertions, 0 deletions
diff --git a/abs/core-testing/mythdb-initial/mythdb.install b/abs/core-testing/mythdb-initial/mythdb.install
new file mode 100755
index 0000000..4834c69
--- /dev/null
+++ b/abs/core-testing/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 $*