[mythtv] database schema

Steve Daniels steve.p.daniels at googlemail.com
Sun May 13 21:13:02 UTC 2007


wad wrote:
> Patrick Reynolds a écrit :
>> On Sun, 13 May 2007, wad wrote:
>>
>>   
>>> I'm looking for a diagram of the mythconverg database. I need it in
>>> order to to a presentation of MythTV. Is that available or does anyone
>>> know how can I make it ?
>>>     
>>
>> mysqldump -u root -d mythconverg
>>
>> It's 770 fields in 80 tables, at least on my system.  I'm not sure what
>> kind of diagram you hope to get.
>>
>> --Patrick
> In fact it's more a conceptual diagram I hope, like a Merise 
> representation :d
> therefore, mysqldump is a good idea, but I prefer the use of phpmyadmin 
> for things like that :D
> 
> Wad
> 

Re: my last post on MySQL Workbench, you'll want to load it up, and go 
to the Database menu, then go to "Reverse Engineering", fill in your 
database details, and keep clicking next selecting all the bits and bobs.

At the end of it, you'll have all 80 odd table shown in the screen, you 
can drag and drop these round the screen, clicking the arrow at the top 
right of each table will show it's contents. Then it's up to you to 
somehow order them, move em round etc. till it looks pretty. If you 
manage it, I would be *very* interested in seeing the final, pretty result.

HTH

Steve Daniels


More information about the mythtv-dev mailing list