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

[Michael T. Dean]

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.

Mike