summaryrefslogtreecommitdiffstats
path: root/abs/core-testing/mythtv/stable/mythdb-initial/mythdb.install
blob: e15231ebe104eeca50cf8b8e40fc209f77273f4f (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
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

	# Run Tweaker to apply settings on top of baseline SQL.
	tweaker.pl
	/bin/rm /tmp/fps # ??? clean up a temp file that will eventually be obsolete anyway
}

post_upgrade() {
	echo "nothing to do"
}

op=$1 
shift 
$op $*