[mythtv-users] does myth 'best practice' have me adding anything to cron?

[steve]

> On Mar 22, 2016, at 7:31 AM, Michael T. Dean <mtdean at thirdcontact.com> wrote:
> 
> On 03/22/2016 01:26 AM, steve wrote:
>> Hi,
>> 
>> I'm running Ubuntu 14.04 LTS with MythTV 0.27.6 installed via PPA, not mythbuntu
>> 
>> Am I supposed to be manually adding anything to cron for myth?
>> 
>> For example, am I supposed to be crontabbing the running of mythfilldatabase every so often?
> 
> No, you should have mythbackend run mythfilldatabase for you.
> 
>> I found reference to some other cron files in some other thread, I am guessing mythbuntu-desktop or maybe myth-control-centre created them?:
>> 
>> /etc/cron.d/mythbuntu-bare
>> /etc/cron.daily/mythexport
>> /etc/cron.daily/mythtv-database
>> /etc/cron.daily/optimize_mythdb
>> /etc/cron.daily/optimize_mythdb.pl
>> /etc/cron.weekly/mythtv-database
> 
> Chances are the database ones are all just ones people have created to run optimize_mythdb.pl (and have nothing to do with mythfilldatabase) , which checks and attempts to repair MythTV's MySQL database tables and optimized the indices and some other stuff.  This action isn't performed automatically by MythTV because it's dangerous--if something goes wrong, you could lose data. Therefore, users are forced to do it themselves.  The safest way is manually/interactively when MythTV is not running (with understanding of the process and what can go wrong and how to recover when it does), though in general, the danger is small enough that you can run it in a daily cron and it is likely to do more good than harm.
> 
> Mike

OK thanks.  So I havent gotten to learn about optimize_mythdb.pl yet but its on my todo list.