[mythtv-users] moving database from FC4 to gentoo (mysql 4 to 5)

Brad Fuller bradallenfuller at yahoo.com
Sun Feb 11 23:21:23 UTC 2007



David Campbell wrote:
> Brad Fuller wrote:
>   
>> Thanks David, that worked!
>> However, if I go to mythtvsetup, none of the cards are setup. I've setup 
>> several MythTVs, but never moved a database (always did it from scratch) 
>> so this is new to me.
>>
>> I would have figured that mythtv-setup would have all the cards, 
>> channels, etc filled in. I see that I have channel data, but no card or 
>> input source data. Why would this be?
>>     
> Could it because the hostname of the server has changed?
>   

Yep, now it almost works. User "root" works ok, but when I'm in user 
"mythtv" I get a constant barrage of error messages that the host 
(called 'killtivo') is not allowed to connect to the MySql server. I 
looked in /etc/mysql/my.conf but I don't see anything out of the 
ordinary. Probably need to add "killtivo" to some file somewhere!


>   
>
>
> it's localhost, like it was. But, maybe I really had the real one in there. I'll try it.
> mysql -uroot -p
>
> mysql> use myhconverg;
> mysql> select cardid,cardtype from capturecard;
>
> If you get a sensible output then you just need to tell myth about it.
>
> If myth should already know about it then check what interfaces mysqld 
> is listening on:
>
> netstat -an | grep 3306 | grep -i listen
>   
I think it's right. The only result was:

tcp 0 0 0.0.0.0:3306 0.0.0.0:* listen

(sorry, I would be searching the gossamer server if the search server 
was working)



More information about the mythtv-users mailing list