[mythtv-users] How to delete mythfrontend client settings

[Mike Perkins]

Anthony Giggins wrote:
>> Nick Morrott wrote:
>>> On 10/03/2008, Jean-Yves Avenard <jyavenard at gmail.com> wrote:
>>>
>>>> Hi
>>>>
>>>>  Since I've upgraded mythtv my mac client running mythfrontend only
>>>>  displays a green screen.
>>>>
>>>>  How can I delete all the settings related to a specific host in
>> mysql ?
>>> I recommend you backup the DB before editing it directly. However:
>>>
>>> mysql> SELECT DISTINCT `hostname` FROM `settings`;
>>>
>>> will show you the various hostnames/identifiers with settings.
>>>
>>> mysql> DELETE FROM `settings` WHERE `hostname` = 'identifier';
>>>
>>> will delete all settings for the machine using the chosen identifier.
>>>
>>>
>> I'd been wondering how to do this myself from the mysql client.  Ta
>> muchly for the demo.
>>
>> Sarah
> 
> Me too.
> 
> Thanks
> Anthony
> 
Seems to me that mythtv-setup could do with an option to "display all known 
hosts" followed by a "remove all information relating to <hostname>" option.

Save a lot of horsing about with SQL. Quite a lot of folks including myself have 
had to do similar, especially in the early stages where we are setting up test 
machines for experimenting with backend/frontend/hardware/distro variables.

Mike Perkins