[mythtv-users] mysql database setup help

[Jake Sallee]

On Tuesday 15 August 2006 14:44, Tom Lichti wrote:
> Christopher Friend wrote:
> >  >> prompt:/usr/share/mythtv/database> mysql -u root < mc.sql
> >  >> bash: mc.sql: No such file or directory
> >  >>
> >  >> I don't think the error message could be stated any more clearly.
> >
> > Well, it could say something like:
> >
> > bash: mc.sql: No such file or directory. You are trying to set up the
> > database with a file called mc.sql from /usr/share/mythtv/database.
> > Unfortunately this file cannot be found. Please locate a copy elsewhere,
> > place it in same directory and try again.
>
> But the error message is an OS level message, it doesn't have anything
> to do with Myth TV.

I knew what the error meant, it was fine.  I'm not that much of a newbie.  ;)  
What I think is misleading about the documentation I've found for installing 
mythtv, both on the mythtv.org wiki and from the guide i was using, was that 
the instructions said, "to setup the initial database, run this 
command:  /usr/share/mythtv/database> mysql -u root < mc.sql"

I was under the impression by running that command, mysql was going to create 
database "mc.sql", especially since mc.sql didn't exist in the database 
directory.  So, I ran locate and found the file 
in /usr/share/doc/packages/mythtv/database/mc.sql

That is what stumped me.

-- 



Jake Sallee  spark at breathedeeply.com
www.breathedeeply.com

Registered Linux User #358012  http://counter.li.org
Open SuSE Linux http://www.opensuse.org
K Desktop Environment http://www.kde.org
Firefox Web Browser  http://www.mozilla.org/firefox