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

Michael T. Dean mtdean at thirdcontact.com
Tue Oct 2 16:00:31 UTC 2007


On 10/02/2007 11:12 AM, John Drescher 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?
> In the 4+ years I have been running MythTV, I have never seen it not
> "just work" after a power outage but to be safe you can run mysqlcheck
>
> http://www.databasejournal.com/features/mysql/article.php/3300511

Or, better (since it does a bit more for you and the "command-line" is
known to work properly), run optimize_mythdb.pl from the contrib directory.

Mike


More information about the mythtv-users mailing list