[mythtv-users] Remove dead slave server from database?

[Nick Morrott]

On 03/04/2009, Robert McNamara <robert.mcnamara at gmail.com> wrote:

>  > Seems strange to me that the database doesn't have something akin to a
>  > slave server ID and a simple command to remove everything related to
>  > that server ID. I guess not though.
>
>
> It's not myth's fault, it's just how databases work.  You can't reset
>  the counter on the whole table without truncating th table.

Whilst TRUNCATEing the table might be the most obvious way to reset
everything to a pristine state, you can issue:

mysql> ALTER TABLE mytable AUTO_INCREMENT = 1;

on an existing table to reset the auto_increment value.

It _is_ the fault of MythTV that it does not provide a way for the
master backend to selectively remove entries for slave backends, or
provide the user with details of a current card's ID in mythv-setup to
limit the "status says card # 20 is going to record later but I only
have 2 cards" scenario mentioned in Mike's linked posts.

If a user has 10 slave backends, and one dies, current wisdom/features
suggests the end-user should "Delete All" capture cards and then
manually reconfigure the other 9 slaves. To me, this rather sounds
like the option to selectively remove a particular slave backend from
within a master backend's mythtv-setup session is a feature that more
than a few users would use.

Nick

-- 
Nick Morrott

MythTV Official wiki:
http://mythtv.org/wiki/
MythTV users list archive:
http://www.gossamer-threads.com/lists/mythtv/users

"An investment in knowledge always pays the best interest." - Benjamin Franklin