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

Chris Isip cmisipster at gmail.com
Sat Jan 23 14:25:09 UTC 2021


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.

Thanks,

Here are the contents of the displayprofilegroups dump"

CODE START--------

CREATE TABLE `displayprofilegroups` (
  `name` varchar(128) NOT NULL,
  `hostname` varchar(64) NOT NULL,
  `profilegroupid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`name`,`hostname`),
  UNIQUE KEY `profilegroupid` (`profilegroupid`)
) ENGINE=Aria AUTO_INCREMENT=35 DEFAULT CHARSET=utf8 PAGE_CHECKSUM=1
TRANSACTIONAL=1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `displayprofilegroups`
--

LOCK TABLES `displayprofilegroups` WRITE;
/*!40000 ALTER TABLE `displayprofilegroups` DISABLE KEYS */;
INSERT INTO `displayprofilegroups` (`name`, `hostname`, `profilegroupid`)
VALUES ('OpenGL Normal','myxps8100.chris.net',11),('OpenGL High Quality','
myxps8100.chris.net',10),('High Quality','myxps8100.chris.net
',4),('Normal','myxps8100.chris.net',5),('Slim','myxps8100.chris.net',6),('VDPAU
High Quality','myxps8100.chris.net',7),('VDPAU
Normal','myxps8100.chris.net',8),('VDPAU
Slim','myxps8100.chris.net',9),('OpenGL Slim','myxps8100.chris.net',12),('High
Quality','cmisip-Dell-DM051',13),('Normal','cmisip-Dell-DM051',14),('Slim','cmisip-Dell-DM051',15),('VDPAU
High Quality','cmisip-Dell-DM051',16),('VDPAU
Normal','cmisip-Dell-DM051',17),('VDPAU
Slim','cmisip-Dell-DM051',18),('OpenGL High
Quality','cmisip-Dell-DM051',19),('OpenGL
Normal','cmisip-Dell-DM051',20),('OpenGL
Slim','cmisip-Dell-DM051',21),('High Quality','rasp3myth.chris.net
',22),('Normal','rasp3myth.chris.net',23),('Slim','rasp3myth.chris.net',24),('High
Quality','HP8300',25),('Normal','HP8300',26),('Slim','HP8300',27),('VDPAU
High Quality','HP8300',28),('VDPAU Normal','HP8300',29),('VDPAU
Slim','HP8300',30),('OpenGL High Quality','HP8300',31),('OpenGL
Normal','HP8300',32),('OpenGL Slim','HP8300',33),('VAAPI
Normal','HP8300',34);
/*!40000 ALTER TABLE `displayprofilegroups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `displayprofiles`


CODE END---------
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20210123/74ccf323/attachment.htm>


More information about the mythtv-users mailing list