[mythtv-users] Re:slight database problem v.12 RPM

[Jarod C. Wilson]

On Monday, Oct 27, 2003, at 23:49 US/Pacific, Keola wrote:

>> A clean setup in 12 populates the >database it's self - so once you 
>> are
>> sure the database is empty
>> - no tables- run the mythtvsetup .
>
> I'm also running into this problem from a clean (my first) install.  
> I'm not sure how to verify that the database is empty (searches only 
> turned up this thread), and I'm not sure how to force mythtvsetup to 
> run and ignore the error message about the populated database.  :(  
> And I was this close to recording the first episode of '24' tomorrow 
> night...

Crap. I see what's going on... For starters, the mythtv docs aren't 
quite accurate anymore... (I know, submit a patch :)

You're correct Keola, on a completely fresh install (which I guess I 
wasn't exactly doing previously), the first time it is run (even in the 
rpms), mythtvsetup tries to populate the mythconverg database. If you 
already have it populated, by manually pushing in the mythtv mc.sql, 
it'll complain about stuff already being in there. If you drop the 
database, it'll complain, because the database doesn't exist. This just 
worked for me:

$ mysql -u root
mysql> drop database mythcoverg;
mysql> create database mythcoverg;
mysql> quit;
$ mythtvsetup

This'll create an empty mythcoverg database, which mythtvsetup will 
populate the first time it is run.

One little problem I see with this method though... If you already have 
a root password set for mysql, mythtvsetup fails to connect to the 
database...

I'm temporarily putting a big fat disclaimer at the top of my guide, 
because there are still quite a few changes in both MythTV and ATrpms 
that I need to account for. It's been a busy few days, with far more 
breakage than I'd anticipated. I'll get a corrected version up as soon 
as possible.

--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: not available
Type: application/pgp-signature
Size: 186 bytes
Desc: not available
Url : http://mythtv.org/pipermail/mythtv-users/attachments/20031028/38a27903/attachment.pgp