[mythtv-users] Tuner numbers - 1 & 3 (no 2)?

[Bruce Markey]

Bruce Markey wrote:
> Matthew Carle wrote:
> 
>> Thanks Nick,
>>
>> Option 1 doesn't work so it looks like I'll have to edit the database. 
>> Just
>> have to figure out how... My SQL knowledge is very patchy.
> 
> 
> http://www.mythtv.org/docs/mythtv-HOWTO-22.html#ss22.5
> 
> $ killall mythbackend
> $ mysqldump -u mythtv -pmythtv mythconverg -c > mythtv_backup.sql
> $ mysql -u mythtv -pmythtv mythconverg
> mysql> update capturecard set cardid=2 where cardid=3;
> mysql> update cardinput set cardid=2 where cardid=3;
> $ mythbackend

Check that. It is possible (probable) that there is a capturecard
entry for 2 that needs to be removed before the update would work:

$ killall mythbackend
$ mysqldump -u mythtv -pmythtv mythconverg -c > mythtv_backup.sql
$ mysql -u mythtv -pmythtv mythconverg
mysql> delete from capturecard where cardid=2;
mysql> update capturecard set cardid=2 where cardid=3;
mysql> delete from cardinput where cardid=2;
mysql> update cardinput set cardid=2 where cardid=3;
$ mythbackend

--  bjm