[mythtv-users] How to copy 'frontend' portion of mysql database

[Michael T. Dean]

On 01/09/2010 07:31 PM, Ronald Frazier wrote:
>> Or, better, just use the GUI settings to copy the values.  After all, 100%
>> of the data integrity rules in MythTV are managed by MythTV code.  The
>> database doesn't help you to do things right.  Therefore, unless you know
>> for sure exactly what you're doing and all the requirements on all the data
>> you're touching and all the data that references the data you're touching,
>> you're likely to create problems.
>>
>> Since, IMHO, the MythTV data is the most valuable portion of the entire
>> system, risking corrupting your data so you don't have to spend 1min 15sec
>> clicking through the profiles in the settings.
>>
>> When you factor in all the time of yours--and others--you spent discussing
>> this on the list, you've already wasted a /lot/ more time than it takes to
>> just use the GUI to set up the profiles.
>>
>> Mike "It ain't your database--it's Myth's--so don't touch it" Dean
>>     
> Whatever. That's what backups are for. There are tons of things I do
> that could be done faster, but
> 1) Doing them the way I do is enjoyable
> 2) It may be a net loss to me, but doing so is a net gain for everyone
> I help. Maybe somebody will take my code and turn it into an actual
> patch to build this functionality into myth (either in the gui, or one
> of the helper add-on scripts)
>
> Besides, copying manually is error prone. Maybe you missed it, but
> this wasn't just about the playback profiles...this was about EVERY
> SETTING USED BY THE FRONTEND. That's a lot of settings, with plenty of
> opportunities to miss things or do it wrong.

But if you had instead spent your time working on 
http://svn.mythtv.org/trac/ticket/6064#comment:2 , perhaps we could 
finally do it right.

Mike