[mythtv-users] Deleting Tuner Cards from mythtv-setup

[Yan Seiner]

Michael T. Dean wrote:
>
> I'd do it Brian's way, though.  It's much easier to do it right the
> first time, and the only way to know that it's right is to do a "Delete
> all capture cards" and re-create them all and re-connect inputs to video
> sources.  The only way to know it's not right is to wait until a
> failure, so if you don't want a failure... :)
>   
I've got one of  those half-screwed up setups.

I've deleted tuners but no joy.

The problem lies in cardinput:

LOCK TABLES `cardinput` WRITE;
/*!40000 ALTER TABLE `cardinput` DISABLE KEYS */;
INSERT INTO `cardinput` VALUES 
(1,0,0,'',NULL,0,'N',NULL,'7',1,NULL,NULL,11700000,10600000,9750000,'',1,0,0,0,0),(2,1,1,'Tuner 
1','',0,'N','','28',1,NULL,NULL,11700000,10600000,9750000,'',1,0,0,6,0),(3,2,2,'DVBInput',NULL,0,'N',NULL,'28_1',1,NULL,NULL,11700000,10600000,9750000,'',1,0,0,0,0);
/*!40000 ALTER TABLE `cardinput` ENABLE KEYS */;
UNLOCK TABLES;


That first entry is bogus.

How do I delete it (short of hand-editing the database and dumping it back)?

--Yan