summaryrefslogtreecommitdiffstats
path: root/abs/mv-core/mythdb-initial/mythdb.install
diff options
context:
space:
mode:
Diffstat (limited to 'abs/mv-core/mythdb-initial/mythdb.install')
-rwxr-xr-xabs/mv-core/mythdb-initial/mythdb.install31
1 files changed, 31 insertions, 0 deletions
diff --git a/abs/mv-core/mythdb-initial/mythdb.install b/abs/mv-core/mythdb-initial/mythdb.install
new file mode 100755
index 0000000..bc1db20
--- /dev/null
+++ b/abs/mv-core/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 = 'myhost' ]
+ 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/myhost/$HOST/g" /data/database/mc.sql.initial > /data/database/mc.sql.fixed
+ sed -e "s/myhost/$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 $*