From 9b57bfb2f2074613a60b29518b0671cbc7eff711 Mon Sep 17 00:00:00 2001
From: James Meyer <james.meyer@operamail.com>
Date: Mon, 29 Oct 2012 14:06:12 -0500
Subject: mythtdb-initial: load mysql timezones, which is needed for mythtv .26

---
 abs/core/mythdb-initial/PKGBUILD       | 2 +-
 abs/core/mythdb-initial/mythdb.install | 2 ++
 2 files changed, 3 insertions(+), 1 deletion(-)

diff --git a/abs/core/mythdb-initial/PKGBUILD b/abs/core/mythdb-initial/PKGBUILD
index e6f3afa..f02d108 100755
--- a/abs/core/mythdb-initial/PKGBUILD
+++ b/abs/core/mythdb-initial/PKGBUILD
@@ -1,6 +1,6 @@
 pkgname=mythdb-initial
 pkgver=2
-pkgrel=34
+pkgrel=35
 pkgdesc="setup the initial mythtv database for linhes"
 url=""
 license=""
diff --git a/abs/core/mythdb-initial/mythdb.install b/abs/core/mythdb-initial/mythdb.install
index e55fa3f..be4e64f 100755
--- a/abs/core/mythdb-initial/mythdb.install
+++ b/abs/core/mythdb-initial/mythdb.install
@@ -2,6 +2,8 @@ mydate=`date +%m-%d-%y`
 HOST=`hostname`
 post_install() {
 	mysqldump mythconverg   >/data/database/mythconverg.${mydate}.sql
+	#load timezone info for mythtv .26
+	mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root  mysql
 	mysql -u root -e 'drop database mythconverg;'
     mysql -u root -e 'create database mythconverg;'
 
-- 
cgit v0.12

