[mythtv-users] Database upgrade fails from 0.18.1 to 0.19

[Neil M.]

Thanks, I've already tired that a few times.  The database seems to restore 
correctly.  I'm thinking the problem is related to it not being able to 
determine a value for Current Schema Version?

Neil

>From: Ramon Redondo <malinon at gmail.com>
>Reply-To: Discussion about mythtv <mythtv-users at mythtv.org>
>To: Discussion about mythtv <mythtv-users at mythtv.org>
>Subject: Re: [mythtv-users] Database upgrade fails from 0.18.1 to 0.19
>Date: Mon, 13 Feb 2006 17:34:04 -0600
>
>On 2/13/06, Neil M. <nabber00 at hotmail.com> wrote:
> >
> > When trying to run mythbackend I get the following error:
> >
> > 2006-02-13 12:47:31.049 Using runtime prefix = /usr/local
> > 2006-02-13 12:47:31.070 New DB connection, total: 1
> > 2006-02-13 12:47:31.073 Connected to database 'mythconverg' at host:
> > localhost
> > 2006-02-13 12:47:31.078 Current Schema Version:
> > 2006-02-13 12:47:31.080 Newest Schema Version : 1123
> > 2006-02-13 12:47:31.081 New DB connection, total: 2
> > 2006-02-13 12:47:31.083 Connected to database 'mythconverg' at host:
> > localhost
> > 2006-02-13 12:47:31.084 Setting Lock for Database Schema upgrade. If you
> > see
> > a long pause here it means the Schema is already locked and is being
> > upgraded by another Myth process.
> > 2006-02-13 12:47:31.086 New DB connection, total: 3
> > 2006-02-13 12:47:31.087 Connected to database 'mythconverg' at host:
> > localhost
> > 2006-02-13 12:47:31.090 Told to create a NEW database schema, but the
> > database
> > already has 36 tables.
> > If you are sure this is a good mythtv database, verify
> > that the settings table has the DBSchemaVer variable.
> >
> > 2006-02-13 12:47:31.091 Database Schema upgrade FAILED, unlocking.
> > 2006-02-13 12:47:31.092 Couldn't upgrade database to new schema
> >
> > Running mythtv-setup doesn't help either, I get a bunch of errors about
> > 'mythconverg.settings' not existing, I assume since the database isn't
> > properly upgraded.  Does anyone have any ideas?  I'd really like to keep
> > my
> > old data if at all possible.  Thanks.
> >
> > Neil
>
>
>
>I'd suggest restoring your database from the backup you made according to
>1.3 of the docs:
>http://www.mythtv.org/docs/mythtv-HOWTO-1.html#ss1.3
>http://www.mythtv.org/docs/mythtv-HOWTO-23.html#backupdb


>_______________________________________________
>mythtv-users mailing list
>mythtv-users at mythtv.org
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users