[mythtv-users] mythtvsetup-0.12 and database problem

[Jarod C. Wilson]

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

-- 
Jarod C. Wilson, RHCE

Got a question? Read this first...
     http://catb.org/~esr/faqs/smart-questions.html
MythTV, Red Hat Linux 9 & ATrpms documentation:
     http://pvrhw.goldfish.org/tiki-page.php?pageName=rh9pvr250
MythTV Searchable Mailing List Archive
     http://www.gossamer-threads.com/archive/MythTV_C2/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 186 bytes
Desc: This is a digitally signed message part
Url : http://mythtv.org/pipermail/mythtv-users/attachments/20031030/114d2f7e/PGP.pgp