[mythtv-users] Cleaning up database

[Mike Carron]

On 10/12/2014 06:27 PM, Thomas Mashos wrote:
> On Sun, Oct 12, 2014 at 4:55 PM, Mike Carron <jmcarron at starstream.net> wrote:
>> On 10/12/2014 03:41 PM, Mark Perkins wrote:
>>>
>>>> On 13 Oct 2014, at 7:49 am, "Mike Carron" <jmcarron at starstream.net>
>>>> wrote:
>>>>
>>>> Over multiple iterations of installing different FE configurations I have
>>>> a lot of obsolete configuration data in the database. Is there a simple way
>>>> of cleaning it out? I don't do MySQL and I don't trust myself to mess with
>>>> the contents directly.
>>>>
>>>> --
>>>> mike
>>>>
>>>> _______________________________________________
>>> Short answer: no. Long answer: even directly manipulating the database to
>>> do this is strongly discouraged by the devs but if you really really wanted
>>> to someone can probably give you some mysql commands to run. Recommend you
>>> back up first.
>>>
>> ***
>> I'm not going to directly manipulate the database. Backup idea: Is it
>> possible to export recording rules from an existing database to a new one? I
>> don't mind creating a fresh database on a new MBE but I don't want to lose
>> my recording rules, reconstructing them is a pain.
>>
>> mike
>>
>>
>> _______________________________________________
>> mythtv-users mailing list
>> mythtv-users at mythtv.org
>> http://www.mythtv.org/mailman/listinfo/mythtv-users
>> http://wiki.mythtv.org/Mailing_List_etiquette
>> MythTV Forums: https://forum.mythtv.org
> This might just sound crazy, but why the need to go clean up anything
> in the DB? Is it hurting something?
>
>
***
Maybe it's just feel-good. It's been my experience that obsolete content 
that's occupying space eventually causes a problem.

mike