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

[Gary Buhrmaster]

On Tue, Dec 31, 2013 at 10:54 PM, Jay Ashworth <jra at baylink.com> wrote:
> ----- Original Message -----
>> From: "Gary Buhrmaster" <gary.buhrmaster at gmail.com>
....
>> As an aside, I would recommend (for a database) to not
>> only backup the database, but to run maintenance jobs
>> to validate the integrity, and update statistics on a
>> regular basis.
>
> There's a second script that does that, is there not?

Yes, if you are dealing with just MythTV and using
the common configuration of a a dedicated MySQL
database engine, the optimize_mythtv.pl script is
what one would likely use.  More complex configurations
(and scripts) are sometimes necessary.

Gary