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

[MythTV]

Daniel Arfsten wrote:
> I had a power outage at my house this morning. I got an email that almost 
> all my mysql databases are either still open by a user or were not shut down 
> properly. Obvioulsy I know that they were not shutdown properly because of 
> the power outage.
>
> My question, Is there anything I have to do as far as repairing them or 
> anything like that or will myth "just work" despite them being shut down 
> improperly?
>   

Look in the contrib directory at optimize_mythdb.pl.  It will repair and 
optimize your myth tables.  Many people run it from cron nightly.

Michael