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
_______________________________________________
mythtv-users mailing list
[email protected]
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
