[mythtv-users] database issues: 0.21 to trunk

[Greg Woods]

On Thu, 2009-04-02 at 22:09 -0400, Michael T. Dean wrote:
> On 04/02/2009 09:48 PM, Greg Woods wrote:

> > # mysqldump mythconverg > mythconverg.sql
> > mysqldump: Got error: 1146: Table 'mythconverg.weatherdatalayout'
> > doesn't exist when using LOCK TABLES

I have determined that, somehow, I'm screwed. I copied over
the /var/lib/mysql/mythconverg files from the old system to another
32-bit system running the same distro (Fedora 8) as the old system, and
I get the same error when I try to run mysqldump there. Obviously the
old database is corrupted and I'm screwed. It probably got corrupted
when the system died. I'll either have to use a relatively old backup or
find some other way to get my recording info into a newly-created
database (I think I read there is a script that can help with this?)

--Greg