[mythtv-users] incorrect keyfile for table displayprofilegroups , try to repair

[Michael T. Dean]

On 01/23/2021 11:05 AM, Michael T. Dean wrote:
> On 01/23/2021 09:25 AM, Chris Isip wrote:
>> My mythtv database cannot be backed up because the backup script 
>> fails due to the above stated problem.
>>
>> The backend otherwise runs fine.  I use raspberry pi's running Kodi 
>> as frontend.
>>
>> I tried all the possible solutions I found on the web and there is no 
>> fixing the table.
>>
>> I have a backup of the database from ~3 years ago and I managed to 
>> isolate the table in question and save it to a file via a selective 
>> mysqldump.
>>
>> Is it safe to delete the table and then recreate it by importing from 
>> the table sql backup?
>>
>> I am using an older version of Mythtv and my database is XmasGift.  
>> Incidentally, how can I check the database version of the backup 
>> database? I don't want to overwrite a portion of the running database 
>> with an older version of the displayprofile table.
>>
>> Alternatively, since I have no mythfrontends running, can I just 
>> issue a 'truncate displayprofile` command and delete the contents of 
>> the table.  I don't know if the command will execute given that the 
>> table is corrupt.
>>
>> I would appreciate any mysql command fu's that you can recommend to 
>> fix the problem.
>>
>
> Another thing to check is whether you have full partitions--including 
> the tmp partition.  This is often the cause of "unfixable" incorrect 
> key file errors.  Lots of distros make small tmpfs file systems, which 
> don't play well with other-than-trivial databases.

Oh, and often your MySQL error log will give more/better information.

Mike