[mythtv-users] mysqlrepair all tables on startup

[Nick Rout]

On Wed, Jan 27, 2010 at 2:02 PM, Raymond Wagner <raymond at wagnerrp.com> wrote:
> On 1/26/2010 17:55, Glenn B. Lawler wrote:
>>
>> I would like to run a script with:
>>
>> mysqlrepair mythconverg {tablename}
>>
>> for each table on startup.
>>
>> I am running MythTV 0.21 under gentoo.
>>
>> Could someone send me information about how to include such a script in
>> the startup procedure?
>>
>
> What you ask has nothing to do with mythtv, and doesn't belong on this
> mailing list.

don't be a pedant, of course it belongs here!

> That said, under Gentoo, '/etc/init.d/local' is used for
> general purpose commands, and runs the '/etc/conf.d/local.start' and
> '/etc/conf.d/local.stop' scripts.
>
> Now what you really should be asking is why do you need to repair your
> tables on every reboot.  If your system is unstable, that should be fixed,
> rather than trying to work around some mysql issues as a result.  If you
> have power issues that cause your system to shut down, you should invest in
> a UPS.

True.

On most distros drop an executable copy of optimize_mythdb.pl into
/etc/cron.daily/