[mythtv-users] incorrect keyfile for table displayprofilegroups , try to repair
Michael T. Dean
mtdean at thirdcontact.com
Sat Jan 23 16:06:56 UTC 2021
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
>> 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.
More information about the mythtv-users