[mythtv-users] Database upgrade problems with weather

[Michael T. Dean]

(fixed top-posting/quoting)

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