[mythtv-users] REMINDER: Back Up Your Database.

[jedi]

On Fri, Jan 03, 2014 at 11:50:41AM +0000, Paul Gardiner wrote:
> On 02/01/2014 20:53, Karl Newman wrote:
> >On Thu, Jan 2, 2014 at 11:46 AM, Paul Gardiner <lists at glidos.net
> ><mailto:lists at glidos.net>> wrote:
> >
> >    The reason I use mysqldump is because it allows me to backup or
> >    transfer between machines all my databases, not just mythconverg,
> >    in one simple command. Probably if I was about to do so for the first
> >    time now, knowing the recommendation, I'd use mythconverg_backup for
> >    just that one database, but given my mythconverg has been through
> >    the mysqldump process many times, including one time that swapped
> >    from MySQL to Maria without my realising, I don't imagine I'd gain much
> >    safety in moving to mythconverg_backup now.
> >
> >
> >Just because you haven't had any problems yet doesn't mean you should
> >assume you won't have any problems in the future... There could
> >conceivably be changes in myth in the future which could break your
> >backup scheme and you might not realize it until it was too late.

    mysql is a database engine that can't be counted on to ensure 
referential integrity. Any malfunctioning code can run amok and 
trash the database. So ignoring the potential problem of an inconsistent 
database or assuming it's just end user error really isn't appropriate. 

[deletia]