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

[Michael T. Dean]

On 04/03/2009 12:01 PM, Jan Ceuleers wrote:
> Robert McNamara wrote:
>> 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.
>
> To be fair, it's actually the database schema's fault (for using the 
> auto-numbering thingie).

The numbers are meaningless.

> So yes, if you design a schema that relies on automatically-assigned 
> numbers (by the database) then you run into problems when you want to 
> support use cases that involve deleting things. 

Or, if you write an application that requires MySQL 3.23, which does 
/not/ allow specifying the data constraints within the database, it 
means you have to put them in the application.

Mike