[mythtv-users] Cleaning up database
Mike Carron
jmcarron at starstream.net
Mon Oct 13 02:42:51 UTC 2014
On 10/12/2014 07:12 PM, Michael T. Dean wrote:
> On 10/12/2014 09:53 PM, Mike Carron wrote:
>> On 10/12/2014 06:27 PM, Thomas Mashos wrote:
>>> On Sun, Oct 12, 2014 at 4:55 PM, Mike Carron wrote:
>>>> On 10/12/2014 03:41 PM, Mark Perkins wrote:
>>>>>
>>>>>> On 13 Oct 2014, at 7:49 am, "Mike Carron" 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.
>>>>>>
>>>>> 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?
>
> Yes, but it doesn't do anything useful.
>
>>>> 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.
>>>>
>>> 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.
>
> Each host's configuration takes up approximately 8kB of HDD space and
> isn't used by anything other than that host (which, if you're no
> longer using that host, means it's not used at all) and doesn't slow
> down any of the things that are actually in use, so there's no real
> reason you need to do any cleanup. MythTV automatically cleans up
> those things that actually do need to be cleaned up (and the lack of
> need to clean up old host configuration is why there is no way to do so).
>
> However, if you really want your placebo:
>
> http://www.mythtv.org/wiki/Database_Backup_and_Restore#Partial_restore_of_a_backup
>
>
> It's just a simple matter of creating a full backup of your database
> (something you should be doing, regularly, anyway, so no additional
> work there); then dropping your database; creating a brand new
> database in MySQL (without breaking/messing up your mythtv
> account/permissions/authentication); running mythtv-setup to create a
> brand new, empty database schema; then exiting mythtv-setup; then
> doing a partial restore; then starting mythtv-setup and reconfiguring
> your master backend (making sure you get everything configured
> correctly); then starting mythbackend; then starting mythfrontend and
> going into settings and reconfiguring mythfrontend correctly; then
> reconfiguring all your plugins correctly; then doing the same
> (configuring mythbackend/mythfrontend/plugins) for all the other hosts
> in your MythTV system. So, if you're certain that you can reconfigure
> your entire system correctly, it's just a matter of spending some
> hours (8+?) redoing all your configuration, then fixing all the things
> that aren't quite right as you notice them over the next
> days/weeks/months of use. IMHO, quite a risk for a process that has
> no tangible benefits.
>
> Mike
>
***
The placebo isn't that important, thanks.
mike
More information about the mythtv-users
mailing list