[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