Help Config MythTV (or mySQL question?)

[menendez]

Hi All,

One of the main reasons I am starting into Linux is to get my PC acting as a DVR.

I dropped a PcHDTV HD-3000 card into my box and installed its firmware files.

Upon boot I see that the new HD was detected. I can see it when I look at HW via

the Mandriva Control Center and noticed that KdeTV dropped a shortcut on the desktop.

So I think I am OK from a HW perspective.

 

Since the KdeTV was on the desktop I thought why not give it a try. (my main goal was MythTV).

KdeTV appears to see the TV card but when I open the channel wizard, I cannot

get past the first window (the next button is greyed out).

I think KdeTV is limited to analog TV though. Is this correct?

If so I know this is the wrong program to use.

 

PcHDTV says to use MythTV. I am trying to configure this via its wiki:

http://mythtv.org/wiki/index.php/User_Manu...al_Installation

 

I am at this part of the wiki:

Setup mysql database mythconverg

Set the root password for the mysql database. (replace mysqlpassword with your own)

Open a Terminal window

 

> mysqladmin -u root password mysqlpassword

 

Setup the initial database The following command will prompt for password

 

> mysql -u root -p < /usr/share/mythtv/database/mc.sql

 

Here is what I did:

[root@localhost jose]# mysqladmin password mysqlpwd

[root@localhost jose]# mysql -p < /usr/share/mythtv/database/mc.sql

bash: /usr/share/mythtv/database/mc.sql: No such file or directory

 

So I think the 1st command worked bu the 2nd did not.

Any recommendations?

Edited September 7, 2007 by menendez

[menendez]

So ultimately it was really a MySQL question.

I figured out that the recommended mysql commands from the MythTV user manual were essentially useless.

I was able to create the needed database by using the MySQL tutorials from this site:

http://dev.mysql.com/doc/refman/5.0/en/database-use.html

 

Now I will see if I can successfully finish the MythTV configuration.

[Guest back_to_linux]

hope to help you, try this :

 

mysql -u root -p < /usr/share/mythtv/initialdb/mc.sql

[tyme]

the problem you're having with this comment:

mysql -p < /usr/share/mythtv/database/mc.sql

is that, apparently, you don't have the file you're sending to the command (/usr/share/mythtv/database/mc.sql). Either you haven't installed the mythtv package yet or the file is located in a different directory.