[mythtv-users] Screwed up display.

[Brad DerManouelian]

On Jun 3, 2007, at 11:15 PM, clemens at dwf.com wrote:

>> On Jun 3, 2007, at 9:59 PM, Reg Clemens wrote:
>>
>>>
>>> I readily admit I am not a mysql person.
>>>> From looking at it, it LOOKS like your statement will do exactly
>>>> what I want
>>> to do, but when I execute it I get an error, viz
>>>
>>> ---
>>>
>>> (as root)
>>> % mysql
>>> mysql> DELETE FROM settings WHERE `hostname` = 'mythtv-fe.dwf.com';
>>> ERROR 1046 (3D000): No database selected.
>>>
>>> ---
>>>
>>> So it looks like I either need to add something to this line, or  
>>> add a
>>> previous line
>>> that selects a database (mythconverg?)
>>>
>>> Any additional help would really be appreciated, I dont want to
>>> have to
>>> completely
>>> rebuild this thing just for this one silly error.
>>
>>
>> use mythconverg;
>>
>> so mysql knows what database you're talking about before you delete
>> rows from a table.
>>
> That gets rid of the error message, but the tables dont seem to get  
> modified
> (I tried the fully qualified name, the name, and the IP address  
> just to cover
> all bases)

This will give you a list of every hostname in that table:

SELECT `hostname` FROM settings GROUP BY `hostname`;

Make sure not to delete anything with NULL as the hostname since they  
are global settings. Anything with a hostname associated with it is  
specific to that frontend.