diff options
Diffstat (limited to 'abs/core-testing/mythdb-initial/mythdb.install')
-rwxr-xr-x | abs/core-testing/mythdb-initial/mythdb.install | 31 |
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 $* |