#!/bin/bash
. /etc/profile
. /etc/systemconfig
set -x
#myhost=`cat /etc/hostname`
myhost=$hostname
hostname $myhost
mount -t proc none /proc
DBFILE=$1

if  [ $SystemType = "Master_backend" -o $SystemType = "Standalone"  ]
    then
        #restore database
        pacman --noconfirm -Sf mysql
        status=1
        mysqlstatus=1
        while [ ! $status = 0  ]
        do
            /etc/rc.d/mysqld stop
            sleep 1
            /etc/rc.d/mysqld start
            mysqlstatus=$?
            if [ $mysqlstatus = 0 ]
            then
                mysql -e "show databases;"
                showstatus=$?
                if [ $showstatus = 0 ]
                then
                   #load database
                   pacman --noconfirm -R mythdb-initial
                   pacman --noconfirm  -S mythdb-initial

                   if [ -f /myth/backup/mythconverg.sql.gz ]
                   then
                        echo "restoring old database"
                        gunzip -c /myth/backup/mythconverg.sql.gz > /myth/backup/mythconverg.sql
                        mysql  mythconverg < /myth/backup/mythconverg.sql

                   else
                        echo "Could not restore old database, mythconverg.sql is missing."
                        touch /tmp/.upgrade_db_failed
                   fi

                    if [ -d /data/srv/mysql/mythconverg ]
                    then
                        status=0
                    fi
                fi
            fi
        done
        rm -f /myth/backup/mythconverg.sql
    else
        exit 0
    fi

#/etc/rc.d/mysqld stop
#umount /proc