[mythtv-users] Database internals

[Paul Gardiner]

Craig Cook <cncook001 at yahoo.com> wrote:
>>> Which means no foreign keys, one area where an inconsistent backup
>would
>>> likely result in the cataclysmic fail on restore predicted on this
>>> 'chere list.  And as you pointed out, it also doesn't support
>>> transactions which means --single-transaction in mysqldump is,
>>> well...doesn't really do much for myisam.
>>
>>Am I reading this right? That's a good thing. So MythTV can't be using
>>foreign keys, hence one less trap to fall into.
>
>I was going to say the opposite.  Foreign keys are usually a good
>thing.

Sorry "good thing" was a bit ambiguous. I meant, the lack of foreign key use in mythtv implies there is one less way in which a mysqldump-based backup might fail.