Arch Linux

arch0r

Member

From: From the Chron-o-John

Registered: 2008-05-13

Posts: 597

[solved] setting up mythtv

hi all :>
i would like to set up mythtv again but unfortunalty the wiki article seems to be outdated
http://wiki.archlinux.org/index.php/MythTV_HOWTO

i can't import any mysql database nor configure mythtv to use mysql

best regards,
arch0r

Last edited by arch0r (2009-12-04 12:13:03)

fastfret79

Member

Registered: 2009-09-05

Posts: 87

Re: [solved] setting up mythtv

if you're having trouble with the bit in the wiki where it says:

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

For some reason that file isn't in the latest arch package, but the file should be as follows:

CREATE DATABASE if not exists mythconverg;
GRANT ALL ON mythconverg.* TO mythtv@localhost IDENTIFIED BY "mythtv";
FLUSH PRIVILEGES;
GRANT CREATE TEMPORARY TABLES ON mythconverg.* TO mythtv@localhost IDENTIFIED BY "mythtv";
FLUSH PRIVILEGES;
ALTER DATABASE mythconverg DEFAULT CHARACTER SET latin1;

So you can just create that file and do the previous command.

Have a look at http://www.mythtv.org/docs/mythtv-HOWTO-6.html#ss6.2 if you need to do anything more elaborate.

arch0r

Member

From: From the Chron-o-John

Registered: 2008-05-13

Posts: 597

Re: [solved] setting up mythtv

it worked! thy a lot

fastfret79

Member

Registered: 2009-09-05

Posts: 87

Re: [solved] setting up mythtv

Glad to help - I've updated the wiki with that info