[mythtv-users] mythtvsetup-0.12 and database problem

[Sean]

Well, hopefully at the end of the weekend I can merely upgrade to 0.12 (Now
that your guide has been updated for us nOObs we see that the upgrade is far
less painful than previously thought ;) ). However, if I HAVE to I will need
this info. Thanks!

-Sean


> Top-posting rearranged...
> 
>>> I'm having the problem below
>>> running rh9 (fresh install) , apt everything with mythtv-0.12
>>> apt-bleeding
>>> I added the databases i.e mc.sql, metadata.sql (various) and the
>>> mythgame sql files.
>>> 
>>> [root at mercury root]# mythtvsetup
>>> Told to create a NEW database schema, but the database already
>>> has 13 tables.
>>> If you are sure this is a good mythtv database, verify
>>> that the settings table has the DBSchemaVer variable.
>>> 
>>> how do I fix this?
> 
> On Oct 29, 2003, at 12:53 PM, Sean wrote:
> 
>> This is the problem that made me install 0.11 instead. I would LOVE to
>> see
>> the answer to this!
> 
> $ mysql -u root -p
> (enter password)
> mysql> drop database mythconverg;
> mysql> quit
> $ mysql -u root -p < /usr/share/doc/mythtv-0.12/database/metadata.sql
> (enter password)
> $ mythtvsetup
> (finish up w/mythtvsetup and mythfilldatabase)
> $ mysql -u mythtv -pmythtv < all-the-other-.sql-files
> 
> I think that should fix it.
> 
> --Jarod