[mythtv-users] Database upgrade problems with weather

[J]

I'm using ubuntu 7.10 about to upgrade to 8.04

in my.conf:
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
# You might want to disable InnoDB to shrink the mysqld process by circa
100MB.
#skip-innodb

On 05/02/2008 02:40 PM, J wrote:

>  From: "Michael T. Dean"
>

> > On 05/02/2008 11:14 AM, J wrote:
> >

> >> When I updated my mythtv the database didn't like it and the
> >> weather part broke, I tired running repairs but how can I fix it?
> >> thank you!

> >
> > MythWeather */requires/* that you enable InnoDB tables in MySQL.  If
> > anyone tells you, "Just do this ... to change it to use MyISAM,"
> > don't follow their advice as it is broken advice that will break
> > your Myth box.

>
>  What is InnoDB?


It's a MySQL storage format.

>  and how do I enable it?


Don't start the server with --skip-innodb and don't put the skip-innodb
option in the MySQL option file (/etc/my.cnf) (and don't do any of the
other things some crazy distro might do to disable InnoDB storage on
your MySQL server).

In other words, you're probably going to have to tell us what distro
you're using so someone using that same distro can tell you how to undo
what the distro did.

Mike
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20080502/f6d14f94/attachment.htm