[mythtv-users] Which DB tables are changed at setup?

[Greg Cope]

On 11 Nov 2013, at 14:42, Tom Lichti <tom at redpepperracing.com> wrote:
> 
>> On Mon, Nov 11, 2013 at 9:30 AM, Raymond Wagner <raymond at wagnerrp.com> wrote:
>>> On 11/11/2013 9:05 AM, Tom Lichti wrote:
>>>> On Mon, Nov 11, 2013 at 7:20 AM, Raymond Wagner <raymond at wagnerrp.com> wrote:
>>>>> On 11/11/2013 1:41 AM, Greg Cope wrote:
>>>>> On 11 Nov 2013, at 04:01, Tom Lichti <tom at redpepperracing.com
>>>>> <mailto:tom at redpepperracing.com>> wrote:
>>>>> 
>>>>>> On Sun, Nov 10, 2013 at 9:23 PM, Raymond Wagner <raymond at wagnerrp.com
>>>>>> <mailto:raymond at wagnerrp.com>> wrote:
>>>>>> 
>>>>>>     On 11/10/2013 9:15 PM, Tom Lichti wrote:
>>>>>> 
>>>>>>         The source code? libs/libmythtv/dbcheck.cpp in particular.
>>>>>> 
>>>>>> 
>>>>>>     dbcheck.cpp is only used for initial database creation and schema
>>>>>>     updates.
>>>>>> 
>>>>>> 
>>>>>> Ah, I misunderstood the question, I thought he wanted to know before
>>>>>> and after an upgrade.
>>>>> 
>>>>> Before and after myth backend setup.
>>>>> 
>>>>> I have already captured all the frontend settings I change.
>>>> 
>>>> Why not just make a database dump?
>>> 
>>> I was going to say the same thing, but the OP said that he did that and it didn't completely answer the question, although I can't imagine why. I've done that myself and it told me exactly what changed. 
>> 
>> I'm not saying use a database dump to see what has changed.  I'm saying just use a database dump, period.  Configure it, make a dump, and then if you want to re-install, restore that dump.  Why fiddle with trying to manually perform the necessary database operations?

I have found DB dumps are fragile between versions.   They also contain loads of transient info like listings or job data.

This pain has all come about from going from 0.23 to 0.27

Greg



> 
> Dunno... :) 
> 
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20131111/6c5aa09c/attachment.html>