[mythtv-users] 0.26 optimize_mythdb.pl Crashes Tables

[Michael T. Dean]

On 04/04/2013 10:53 AM, Brian Long wrote:
> On Thu, Apr 4, 2013 at 10:04 AM, Michael T. Dean wrote:
>
>> On 01/01/2013 12:49 PM, Brian Long wrote:
>>
>>> No, there's no issue with the script--it just calls some MySQL functions
>> against the tables in your database.  If it's causing your database tables
>> to be marked as crashed, you have some serious underlying MySQL and/or data
>> storage issue.
> Still happens to me if I enable the cron job.  Not sure how to debug
> further.  If I run the same commands manually (inside mysql), it works
> fine.  Only when I run the script do I have problems.

I'd recommend doing a complete backup ( 
http://www.mythtv.org/wiki/Database_Backup_and_Restore ), then a full 
restore ( 
http://www.mythtv.org/wiki/Database_Backup_and_Restore#Replacing_an_existing_database 
), and see if that fixes the issue (which is almost definitely with the 
data files--assuming you don't have a *very* buggy version of MySQL 
installed).

Mike