[mythtv-users] [SOLVED] What Happened?

Michael T. Dean mtdean at thirdcontact.com
Mon May 19 23:30:12 UTC 2008


On 05/19/2008 09:55 AM, Ronald Frazier wrote:
>>> Database corruption is a possibility.  Try mysqlcheck.
>>>       
>> Thank you very much!  This did the trick perfectly...
> Now the trick is to keep if from happening again. You might want to
> consider setting this up to run automatically using an @reboot line in
> your crontab. That you won't miss a show if the power fails and
> corrupts the database again. You could also cron it to run
> periodically, but I'd do that in addition to (rather than in place of)
> the @reboot option.

And, really, you should probably be running the script
optimize_mythdb.pl, instead of running mysqlcheck manually.  It works
great in cron, too.

Mike


More information about the mythtv-users mailing list