[mythtv-users] Screwed up display.
myth at dermanouelian.com
Mon Jun 4 06:19:56 UTC 2007
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
>>> 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
> (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.
More information about the mythtv-users