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

[Kirby Vandivort]

http://www.mythtv.org/docs/mythtv-HOWTO-6.html#ss6.4

Says to run mysql < mc.sql (paraphrased) to create the initial
database.  This is still correct.  This is for a completely fresh
install.  If, instead doing the 'create database mythconverg' below,
you follow the instructions above, it will create the database and
give it the passwords as expected.

Unless RPM installs are screwing something else up, I don't see
a problem with the docs.

mc.sql contains nothing _but_ the create and grant statements at this
time.  The code itself populates the empty database and then keeps
it up to date, and nothing more.  It trys hard to failsafe if there
are any unexpected complications that it runs into.

Kirby


On Tue, Oct 28, 2003 at 03:18:17AM -0800, Jarod C. Wilson wrote:
> 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/



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


-- 

Kirby Vandivort                      Theoretical and 
Senior Research Programmer            Computational Biophysics 
Email: kvandivo at ks.uiuc.edu          3051 Beckman Institute
http://www.ks.uiuc.edu/~kvandivo/    University of Illinois
Phone: (217) 244-5711                405 N. Mathews Ave
Fax  : (217) 244-6078                Urbana, IL  61801, USA