[mythtv-users] mythbuntu db backups

Daryl McDonald darylangela at gmail.com
Fri Oct 30 13:40:31 UTC 2015 

On Thu, Oct 29, 2015 at 11:55 PM, Mark Perkins <perkins1724 at hotmail.com>
wrote:

>
>
>
>
> On 30 Oct 2015, at 11:42 am, Daryl McDonald <darylangela at gmail.com> wrote:
>
>
>
> On Thu, Oct 29, 2015 at 8:35 PM, Stephen Worthington <
> stephen_agent at jsw.gen.nz> wrote:
>
>> On Thu, 29 Oct 2015 18:48:22 -0400, you wrote:
>>
>> >Greetings Mythizens, in a manual housekeeping effort I've discovered a
>> file
>> >with ten recent mythbuntu db backups in it, I don't use Mythbuntu Control
>> >Center any more so these are dead weight. Can anyone offer a suggestion
>> on
>> >stopping this log rotate process cleanly, I imagine deleting the target
>> >file would cause subterranean problems at some point. I'm quite happy
>> with
>> >the Mythconverg backups and I'm running mythtv 0.27 fixes in a Ubuntu
>> 14.04
>> >desktop environment.  Grazie.
>>
>> As far as I know, the only backup rotation is done by the backup
>> script:
>>
>>   /usr/share/mythtv/mythconverg_backup.pl
>>
>> which is called from:
>>
>>   /etc/cron.weekly/mythtv-database
>>
>
> Yes I have Mythconverg running with a five backup logrotate
>
>>
>> All it does is to do individual backups to files with the date in the
>> name, and then delete the oldest when it does a new backup and there
>> are too many backups already present in the destination directory.
>>
>> There is no software I know of in Mythbuntu 14.04 that will create a
>> file that has multiple backups in it.
>>
>
> Previously I used MCC to generate "Mythbuntu backups, not Mythconverg
> backups
>
>>
>> The standard place the backups are put is:
>>
>>   /var/lib/mythtv/db_backups/
>>
>
> and they are translocated, my  bad
>
>>
>> If they are anywhere else, it is something you have done.  I have set
>> up daily backups to a network drive, and moved my normal weekly
>> backups to a different drive on my backend.
>>
>> Exactly how are the multiple backups stored in the file you found? Are
>> they compressed in some form of archive file?  What is the timestamp
>> on the file?  Making backups, or archiving them, takes a while, so you
>> may be able to find out what is doing it by being around at the time
>> that file is altered, and getting a full process list, and seeing what
>> is actually creating the file:
>>
>
> Yes compressed and one for each of the last ten days
>
>>
>>   ps -ef >processes.txt
>>
>> If it is happening at a bad time of day, you can schedule that command
>> to happen.
>
>
> Timing is not the issue I just want to eradicate the process creating them
> because the Mythconverg backups are sufficient and the Mythbuntu
> unnecessary.
>
>
>
>> To do that, I use a little script called sleepuntil that I
>> found on the net.  I have it in /usr/local/bin:
>>
>> #!/bin/bash
>> set -o nounset
>>
>> ### // Sleep until some date/time.
>> # // Example: sleepuntil 15:57; kdialog --msgbox "Backup needs to be
>> done."
>>
>>
>> error() {
>>   echo "$@" >&2
>>   exit 1;
>> }
>>
>> NAME_PROGRAM=$(basename "$0")
>>
>> if [[ $# != 1 ]]; then
>>      error "ERROR: program \"$NAME_PROGRAM\" needs 1 parameter and it
>> has received: $#."
>> fi
>>
>>
>> CURRENT=$(date +%s)
>> TARGET=$(date -d "$1" +%s)
>>
>> SECONDS=$(($TARGET - $CURRENT))
>>
>> if [[ $SECONDS < 0 ]]; then
>>      error "You need to specify in a different way the moment in which
>> this program has to finish, probably indicating the day and the hour
>> like in this example: $NAME_PROGRAM \"2009/12/30 10:57\"."
>> fi
>>
>> sleep "$SECONDS"
>>
>> # // End of file
>>
>>
>> So you would do a command like:
>>
>> sleepuntil 03:00; ps -ef >processes.txt
>> _______________________________________________
>> mythtv-users mailing list
>> mythtv-users at mythtv.org
>> http://lists.mythtv.org/mailman/listinfo/mythtv-users
>> http://wiki.mythtv.org/Mailing_List_etiquette
>> MythTV Forums: https://forum.mythtv.org
>
>
> I'd rather not reinstall MCC just to stop that process if there is a
> command line solution.
>
> _______________________________________________
>
>
> Daryl I assume you mean 10 backups in a *folder* not *file*?
>

Yes, or more properly a directory.

>
> What is the location of that folder (containing the backups)?
>

/media/storage/Dropbox, I caused this through MCC quite some time ago, and
now that I see eleven ".tar.gz's" in there I bet they're not rotating, but
accumulating as a result of a "rsync restore" I did, I'd guess eleven days
ago.

>
> What is the output of:
> ls -al /etc/cron*
>

 trieli at mythtv:~$ ls -al /etc/cron*
-rw-r--r-- 1 root root  722 Feb  9  2013 /etc/crontab

/etc/cron.d:
total 32
drwxr-xr-x   2 root root  4096 Apr 16  2014 .
drwxr-xr-x 142 root root 12288 Oct 30 09:30 ..
-rw-r--r--   1 root root   188 Feb 19  2014 anacron
-rw-r--r--   1 root root   139 Oct 20  2014 mythbuntu-bare
-rw-r--r--   1 root root   510 Jul  7  2014 php5
-rw-r--r--   1 root root   102 Feb  9  2013 .placeholder

/etc/cron.daily:
total 112
drwxr-xr-x   2 root root  4096 Oct 28 13:15 .
drwxr-xr-x 142 root root 12288 Oct 30 09:30 ..
-rwxr-xr-x   1 root root   311 Feb 19  2014 0anacron
-rwxr-xr-x   1 root root   625 Jul 22  2014 apache2
-rwxr-xr-x   1 root root   376 Apr  4  2014 apport
-rwxr-xr-x   1 root root 15481 Apr 10  2014 apt
-rwxr-xr-x   1 root root   355 Jun  4  2013 bsdmainutils
-rwxr-xr-x   1 root root   384 Mar 23  2014 cracklib-runtime
-rwxr-xr-x   1 root root   256 Mar  7  2014 dpkg
-rwxr-xr-x   1 root root  2211 Jan  6  2014 locate
-rwxr-xr-x   1 root root   372 Jan 22  2014 logrotate
-rwxr-xr-x   1 root root  1261 Apr 10  2014 man-db
-rwxr-xr-x   1 root root   435 Jun 20  2013 mlocate
-rwxr-xr-x   1 root root  2069 Feb  3  2014 mythexport
-rwxr-xr-x   1 root root   448 Mar 25  2015 mythtv-database
-rwxr-xr-x   1 root root  1110 Feb  6  2015 ntp
-rwxr-xr-x   1 root root   831 Nov 22  2014 optimize_mythdb
-rwxr-xr-x   1 root root   831 Feb 17  2015 optimize_mythdb.pl
-rwxr-xr-x   1 root root   249 Feb 16  2014 passwd
-rw-r--r--   1 root root   102 Feb  9  2013 .placeholder
-rwxr-xr-x   1 root root  2417 May 13  2013 popularity-contest
-rwxr-xr-x   1 root root   214 Apr  9  2014 update-notifier-common
-rwxr-xr-x   1 root root   328 Jul 18  2014 upstart

/etc/cron.hourly:
total 20
drwxr-xr-x   2 root root  4096 Apr 16  2014 .
drwxr-xr-x 142 root root 12288 Oct 30 09:30 ..
-rw-r--r--   1 root root   102 Feb  9  2013 .placeholder

/etc/cron.monthly:
total 24
drwxr-xr-x   2 root root  4096 Apr 16  2014 .
drwxr-xr-x 142 root root 12288 Oct 30 09:30 ..
-rwxr-xr-x   1 root root   313 Feb 19  2014 0anacron
-rw-r--r--   1 root root   102 Feb  9  2013 .placeholder

/etc/cron.weekly:
total 48
drwxr-xr-x   2 root root  4096 Oct 26 13:15 .
drwxr-xr-x 142 root root 12288 Oct 30 09:30 ..
-rwxr-xr-x   1 root root   312 Feb 19  2014 0anacron
-rwxr-xr-x   1 root root   730 Feb 23  2014 apt-xapian-index
-rwxr-xr-x   1 root root   427 Apr 16  2014 fstrim
-rwxr-xr-x   1 root root   771 Apr 10  2014 man-db
-rwxr-xr-x   1 root root   448 Apr 17  2014 mythtv-database
-rwxr-xr-x   1 root root   448 Apr 17  2014 mythtv-database~
-rw-r--r--   1 root root   102 Feb  9  2013 .placeholder
-rwxr-xr-x   1 root root   211 Apr  9  2014 update-notifier-common
trieli at mythtv:~$


> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://lists.mythtv.org/mailman/listinfo/mythtv-users
> http://wiki.mythtv.org/Mailing_List_etiquette
> MythTV Forums: https://forum.mythtv.org
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.mythtv.org/pipermail/mythtv-users/attachments/20151030/9fb8b4e6/attachment.html>

More information about the mythtv-users mailing list