Mailing List Archive: Automatic Database Backup Files

Automatic Database Backup Files

Apr 18, 2020, 9:27 AM

Post #1 of 3 (320 views)

I noticed that MythTV is automatically backing up the database into
mythconverg-1344-<date>.sql.gz files. There are two sets of these
files. A daily backup set in $HOME/mythtv and a weekly set in the
recording directory.

I seem to remember setting up the daily backup years ago, but not the
weekly one. The weekly one is redundant and writing to the recording
drive, which I do not want. How can I get stop the weekly backup in the
recording directory?

Jay

_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org

Re: Automatic Database Backup Files [ In reply to ]

mike.bibbings at gmail

Apr 18, 2020, 9:57 AM

Post #2 of 3 (320 views)

Permalink

On 18/04/2020 17:27, Jay Foster wrote:
> I noticed that MythTV is automatically backing up the database into
> mythconverg-1344-<date>.sql.gz files. There are two sets of these
> files. A daily backup set in $HOME/mythtv and a weekly set in the
> recording directory.
>
> I seem to remember setting up the daily backup years ago, but not the
> weekly one. The weekly one is redundant and writing to the recording
> drive, which I do not want. How can I get stop the weekly backup in
> the recording directory?
>
> Jay
>
> _______________________________________________

For Ubuntu based systems when mythtv is installed a weekly backup is
automatically setup in /etc/cron.weekly/

Just remove the file /etc/cron.weekly/mythtv-database

Personally I just move the file to /etc/cron.daily/ to give me a daily
backup and use backuprc to specify how many backups to keep and where to
store the backups.

Mike

_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org

Re: Automatic Database Backup Files [ In reply to ]

mkbloke at gmail

Apr 18, 2020, 10:00 AM

Post #3 of 3 (320 views)

Permalink

On Sat, 18 Apr 2020 at 17:28, Jay Foster <jayf0ster@roadrunner.com> wrote:

> I noticed that MythTV is automatically backing up the database into
> mythconverg-1344-<date>.sql.gz files. There are two sets of these
> files. A daily backup set in $HOME/mythtv and a weekly set in the
> recording directory.
>
> I seem to remember setting up the daily backup years ago, but not the
> weekly one. The weekly one is redundant and writing to the recording
> drive, which I do not want. How can I get stop the weekly backup in the
> recording directory?
>

Are you using a packaged version of MythTV? If so, which one?

It's likely either a file in /etc/cron.weekly or perhaps a systemd timer.

You can just check out the contents of the /etc/cron.weekly directory if
it's cron based and look for a file that will likely be named something
quite obvious to its function like mythtv-database. You can check out the
systemd timers using the command 'systemctl list-units -t timer'.

--
Cheers, Ian