[mythtv-users] Database internals
Paul Gardiner
lists at glidos.net
Sat Jan 4 17:47:39 UTC 2014
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.
More information about the mythtv-users
mailing list