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

[Neil M.]

Ok, I guess I figured out the issue.  For some reason I wasn't getting 
everything with a 'mysqldump' command.  I restored from the binary files 
stored in /var/lib/mysql and ran 'repair table' on a few tables and it 
appears I'm up and running just fine.

Neil

>From: "Neil M." <nabber00 at hotmail.com>
>Reply-To: Discussion about mythtv <mythtv-users at mythtv.org>
>To: mythtv-users at mythtv.org
>Subject: Re: [mythtv-users] Database upgrade fails from 0.18.1 to 0.19
>Date: Mon, 13 Feb 2006 15:53:01 -0800
>
>I don't have a settings table in my backup file, the closest I have a is
>'mamesettings' table.  Is a settings table part of the database schema for
>0.18.1?  Otherwise I don't know why I wouldn't have it.
>
>Neil
>
> >From: "Michael T. Dean" <mtdean at thirdcontact.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 18:45:46 -0500
> >
> >On 02/13/2006 06:40 PM, Neil M. wrote:
> > > 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?
> > >
> >Without a settings table, it would do that.  Did you do a complete
> >restore?  If not, make sure you restore at least the DBSchemaVer row of
> >the settings table.
> >
> >Mike
> >_______________________________________________
> >mythtv-users mailing list
> >mythtv-users at mythtv.org
> >http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>
>
>_______________________________________________
>mythtv-users mailing list
>mythtv-users at mythtv.org
>http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users