[mythtv-users] Repair mysql tables after power failure?

[Mike Perkins]

David Brodbeck wrote:
> On Oct 2, 2007, at 8:59 AM, MythTV wrote:
>> Look in the contrib directory at optimize_mythdb.pl.  It will  
>> repair and
>> optimize your myth tables.  Many people run it from cron nightly.
> 
> If you do this, try to run it during a time when there are no ongoing  
> recordings.  It locks the tables for a prolonged period of time,  
> which can cause problems.
> 
Hmmm. Note to self: add this to startup on the master backend, in such a way it 
runs before the backend starts. The master backend machine currently stays up 
forever, unless there's a power outage. Although I run a script containing this 
around 02:00 every night, I hadn't considered possible corruption after a power 
cut/restart. Filesystems get checked on startup, why not databases?

In fact, does Mysql do anything useful on startup in this regard?

Mike Perkins