[mythtv-users] cardid reset?

[Bruce Markey]

bobnvic at everestkc.net wrote:
> In adding a new PVR-250MCE card recently I had problems
> with it not changing channels.  I ended running setup
> and saying yes to deleting the card and channel info.  
> After putting the card info back in, I noticed that I 
> now had cardids of 4,5 and 6 (no 1,2 or 3).  I ended up
> doing this a couple more times trying to reset the cardid
> and now have cardids of 11,12 and 13.  Changing the values
> directly in capturecard in mysql only messed things up.
> 
> I think everything's working now, but I'd like to reset the
> cardids to 1,2 and 3.  How can I do this?  Is there a
> reason for it to work this way or do I have something messed
> up?

The capturecard 'cardid' field is auto_increment so it will
always use a new, higher number. Probably the easiest way
to reset is to first make new backup:

http://www.mythtv.org/docs/mythtv-HOWTO-21.html#ss21.5

Once you are sure you have a good backup, look in the file
for "CREATE TABLE capturecard (". From the mysql commandline,
"drop capturecard;" then cut'n'paste the 20 or so lines to
recreate the table. Do the same for the "cardinput" table.

Run setup again and the first card will be "1". The scheduler
will use card 1 first, card 2 second and so on so this would
be a good time to consider your order of preference. Note,
/dev/video0 doesn't have to be first and card 1 doesn't even have
to be on the master. I have card 1 on a slave and cards 2 and
5 (last) on a dual tuner master.

http://www.mythtv.org/docs/mythtv-HOWTO-21.html#ss21.12

--  bjm