[mythtv-users] database issues: 0.21 to trunk

[Michael T. Dean]

On 04/02/2009 09:48 PM, Greg Woods wrote:
> Starting up mythbackend from a terminal for the first time, it went
> through the process of upgrading the schema through 15 or 20 versions.
> But at the end, some tables are missing. I see missing tables in the
> frontend log, and even mysqldump complains:
>
> # mysqldump mythconverg > mythconverg.sql
> mysqldump: Got error: 1146: Table 'mythconverg.weatherdatalayout'
> doesn't exist when using LOCK TABLES

You're almost definitely running a misconfigured MySQL server that has 
the InnoDB storage engine disabled.  Some distros do this to save 
memory.  Fix MySQL, then drop your DB, then re-restore the pre-upgrade 
backup.

Mike