[mythtv-users] How to copy channels info to new distro?

[Another Sillyname]

2008/10/5 DaveD <mythtv at guiplot.com>:
> Adam Hirsch wrote:
>> DaveD (mythtv at guiplot.com) wrote:
>>
>>
>>> I was going to just copy the whole thing but thought that perhaps I
>>> should only copy what's necessary since I have some odd problems with my
>>> existing system and would like to avoid copying possible configuration
>>> problems to the new system.
>>>
>>
>>
>>> [...] I have a LOT of manually entered data that I don't want to do over
>>> so a simple re-scan is not an option.
>>>
>>
>> Having recently migrated myself from one system to another, and hearing you
>> say you've got a lot of manually entered data, it sounds to me like you're
>> probably best off carrying the whole DB over rather than sorting through
>> it...  Just my $0.02.
>>
>> Adam
>>
> Part of the reason I'm upgrading is the quirky problems I currently
> have.  The main reason, though, is I'm running FC7 which has not been
> supported for a while.  I figure I'll give it a try just exporting the
> tables I think I'll need.  If something doesn't work (or I still have
> quirky problems) I'll just dump the DB and load from the full dump.
>
> Here's what I've decided to export:
>
> mysqldump -u mythtv -p -t mythconverg record recorded \
> oldrecorded recordedprogram recordedrating \
> recordedmarkup recordedseek channel  videosource > fc7_mythtables.sql
>
> I'll post the results.
>
> DaveD
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>

Dave

yum install mysql-gui-browser mysql-administrator

These are a couple of really good gui frontends for mysql and will
allow you to visually browse the tables looking for errors.  Until I
started using them I really struggled to understand the DB
structure....now I'm pretty comfortable hacking into the db and
editing it directly.

Good luck.