[mythtv-users] Database internals (was: REMINDER: Back Up Your Database.)

[jedi]

On Thu, Jan 02, 2014 at 07:03:51PM -0500, Jay Ashworth wrote:
> ----- Original Message -----
> > From: "Paul Gardiner" <lists at glidos.net>
> 
> > Another thing still bugging me, is why mysqldump doesn't create
> > exact copies of the database. I'd have thought that was what it
> > was intended to do.
> 
> Having spent hours with mysqldump, I'm going to take a swing at this one:
> 
> What the words "exact copy of the database" actually means to you is 
> something that actually varies quite a lot.

[deletia]

> So the best thing to do, if you don't understand all the knobs on mysqldump,
> is to get someone who does to whip you up a quick... scri.. 

...which pretty much just boils down to using the "consistent" option.

Although a MythTV database is likely to be so tiny and low volume as to make
this sort of thing a moot point anyways. You probably could do a "hot backup"
of your mysql datafiles and not end up with garbage.

[deletia]