Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: MythTV: Dev

Re: [mythtv-commits] mythtv commit: r15933 by cpinkham

 

 

MythTV dev RSS feed   Index | Next | Previous | View Threaded


mtdean at thirdcontact

Feb 12, 2008, 4:56 AM

Post #1 of 6 (875 views)
Permalink
Re: [mythtv-commits] mythtv commit: r15933 by cpinkham

On 02/12/2008 12:04 AM, mythtv [at] cvs wrote:
> Author: cpinkham
> Date: 2008-02-12 05:04:05 +0000 (Tue, 12 Feb 2008)
> New Revision: 15933
> Changeset: http://cvs.mythtv.org/trac/changeset/15933
>
>
> Log:
>
> I changed my mind.... Reverting part of [15932]. I think that we should
> still backup the DB if the schema version is empty. It might be empty for
> more than one reason. If this is the initial empty DB the DB backup file
> won't be that large anyway so backing the empty DB up isn't a big issue.

I was just going to mention that I've seen user DB's get broken by
accidentally dropping tables (including the settings table) or by
accidentally deleting settings such as DBSchemaVer (i.e. when a schema
upgrade failed and they're trying to "fix" it), but I see you got there
before me. :) Granted, in these cases the upgrade itself will fail,
but at least the user will have a backup they can use for
http://mythtv.org/docs/mythtv-HOWTO-23.html#ss23.7 .

Thanks,
Mike
_______________________________________________
mythtv-dev mailing list
mythtv-dev [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev


nigel at ind

Feb 12, 2008, 4:46 PM

Post #2 of 6 (834 views)
Permalink
Re: [mythtv-commits] mythtv commit: r15933 by cpinkham [In reply to]

On 12/02/2008, at 11:56 PM, Michael T. Dean wrote:
> at least the user will have a backup they can use for
> http://mythtv.org/docs/mythtv-HOWTO-23.html#ss23.7 .

Which reminds me, the doco needs updating to mention
the new auto-backup files, their storage groups, et c.

Anyone feel motivated?

--
Nigel Pearson, nigel [at] ind|"Gentlemen,
Telstra Net. Eng., Sydney, Australia | you can't fight in here-
Office: 9202 3900 Fax: 9261 3912 | this is the war room!"
Mobile: 0408 664435 Home: 9792 6998 | Dr Strangelove
_______________________________________________
mythtv-dev mailing list
mythtv-dev [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev


rkulagow at gmail

Feb 15, 2008, 3:00 PM

Post #3 of 6 (806 views)
Permalink
Re: [mythtv-commits] mythtv commit: r15933 by cpinkham [In reply to]

Nigel Pearson wrote:
> On 12/02/2008, at 11:56 PM, Michael T. Dean wrote:
>> at least the user will have a backup they can use for
>> http://mythtv.org/docs/mythtv-HOWTO-23.html#ss23.7 .
>
> Which reminds me, the doco needs updating to mention
> the new auto-backup files, their storage groups, et c.

I'll be putting something together; it was ticket 4613 that had the
details, right?

_______________________________________________
mythtv-dev mailing list
mythtv-dev [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev


nigel at ind

Feb 15, 2008, 3:55 PM

Post #4 of 6 (791 views)
Permalink
Re: [mythtv-commits] mythtv commit: r15933 by cpinkham [In reply to]

> I'll be putting something together;
> it was ticket 4613 that had the details, right?

Yep
>

--
Nigel Pearson, nigel [at] ind|Well, I own the hotel
Telstra Net. Eng., Sydney, Australia | and I also live in it.
Office: 9202 3900 Fax: 9261 3912 |My life is very much
Mobile: 0408 664435 Home: 9792 6998 | like Monopoly


_______________________________________________
mythtv-dev mailing list
mythtv-dev [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev


mtdean at thirdcontact

Mar 11, 2008, 11:08 AM

Post #5 of 6 (709 views)
Permalink
Re: [mythtv-commits] mythtv commit: r15933 by cpinkham [In reply to]

On 02/15/2008 06:00 PM, Robert Kulagowski wrote:
> Nigel Pearson wrote:
>
>> On 12/02/2008, at 11:56 PM, Michael T. Dean wrote:
>>
>>> at least the user will have a backup they can use for
>>> http://mythtv.org/docs/mythtv-HOWTO-23.html#ss23.7 .
>>>
>> Which reminds me, the doco needs updating to mention
>> the new auto-backup files, their storage groups, et c.
> I'll be putting something together; it was ticket 4613 that had the
> details, right?

Robert,

Just wanted to give you an update on the database backup stuff as I just
saw a commit to the HOWTO.

Anyway, I think we should leave the database backup documentation as it
is for now. I'm making some pretty major changes to the way it works,
so any docs we create now will be obsoleted in short order (and, I think
it will even change for 0.21 users--more on that later).

We could mention the DB Backups storage group, but it really doesn't
apply to any 0.21 users since we only do an automatic backup when the DB
schema version changes, which will almost definitely only happen on the
initial upgrade--and at that time, the users won't yet have storage
groups. Therefore, since the automatic backup will only run a grand
total of one time, we can leave it out of the docs for now. And, at
this point, I don't feel it's good to encourage the users to "assume"
that Myth will be able to successfully backup the DB (as there are many
ways the built-in backup can fail).

The changes I'm making are inspired by comments from Daniel K., Stuart
M., and Rob S., who suggested a matched pair of scripts--one for backup
and one for restore. Distros can replace these scripts with their own.
The scripts, however, will "abstract" out all the differences in the
backup and restore process, so we'll be able to write HOWTO
documentation for our scripts and it should apply to other distros even
if they replace our scripts.

I have a backup script basically complete (doing the backup,
compression, and rotation) and am working on the restore script. The
restore script will handle full restores (as in #23.5) as well as
"partial" restores (#23.7--moving your data to a new host) as well as
"hostname-change" restores (#23.15). So, once these scripts are
written, we can significantly simplify the HOWTO docs. Both scripts
will be usable by any MythTV user--regardless of which version of MythTV
they're using. And, the backup script can be used from a
startup/shutdown script or a cron job, so it should make it much easier
for users to get and maintain proper backups.

Though the use of those scripts for automatic backups won't be
backported into the 0.21 branch, as mentioned, the 0.21 users really
won't be using the automatic backup stuff, anyway. However, I hope to
either convince the devs to drop a copy of the scripts in the 0.21-fixes
contrib directory or, if nothing else, link to them from the HOWTO
documentation and encourage users to use them with their 0.21 versions.
Therefore, I'd like to see the HOWTO updated to suggest the use of these
scripts even for 0.21 users.

Once I finish the scripts, I will write up the HOWTO documentation for
the database backup/restore, since it's not really your job to do so. I
will also include documentation on the DB Backups storage group (since
that will be something they may want to have set before they upgrade to
0.22). Then, you can simply edit/fix my initial draft rather than doing
all the work yourself.

Hope I wasn't too late in getting this info to you (and hope you haven't
spent any time on it, yet). I just couldn't decide what approach was
best, so I kept flip-flopping between thinking we need to update the
docs and wanting to wait. I'm now hoping to wait.

Thanks,
Mike
_______________________________________________
mythtv-dev mailing list
mythtv-dev [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev


rkulagow at gmail

Mar 13, 2008, 6:10 AM

Post #6 of 6 (700 views)
Permalink
Re: [mythtv-commits] mythtv commit: r15933 by cpinkham [In reply to]

Michael T. Dean wrote:
> On 02/15/2008 06:00 PM, Robert Kulagowski wrote:
>> Nigel Pearson wrote:
>>
>>> On 12/02/2008, at 11:56 PM, Michael T. Dean wrote:
>>>
>>>> at least the user will have a backup they can use for
>>>> http://mythtv.org/docs/mythtv-HOWTO-23.html#ss23.7 .
>>>>
>>> Which reminds me, the doco needs updating to mention
>>> the new auto-backup files, their storage groups, et c.
>> I'll be putting something together; it was ticket 4613 that had the
>> details, right?
>
> Robert,
>
> Just wanted to give you an update on the database backup stuff as I just
> saw a commit to the HOWTO.
...
> Hope I wasn't too late in getting this info to you (and hope you haven't
> spent any time on it, yet). I just couldn't decide what approach was
> best, so I kept flip-flopping between thinking we need to update the
> docs and wanting to wait. I'm now hoping to wait.

No, it's ok. From this point forward the trunk and 0-21 branches will
have separate doc trees so that I can include new features into trunk
without having to have "only in 0.22" caveats all over the place.
_______________________________________________
mythtv-dev mailing list
mythtv-dev [at] mythtv
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-dev

MythTV dev RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.