[mythtv-users] Database internals

[Paul Gardiner]

On 04/01/2014 16:13, Jeff Breitner wrote:
>
>
>
> On Sat, Jan 4, 2014 at 10:28 AM, Gary Buhrmaster
> <gary.buhrmaster at gmail.com <mailto:gary.buhrmaster at gmail.com>> wrote:
>
>     I presume that you know that the MythTV tables default
>     to (and are technically only supported as) with the
>     MyISAM engine.... (*)
>
>
> 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.

P.