[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