Backing up www directory once a day and the DB dump hourly #511

New Issue

gerdneuman · 2022-03-17T21:48:08Z

gerdneuman commented

2022-03-17 21:48:08 +00:00

I want ot backup /var/www/ once a day (at night) but the mysql DB on the same server every hour to borgbase. So after reading https://torsion.org/borgmatic/docs/how-to/make-per-application-backups/ it seems like I have to create two almost identical config files. Fine. Still, I do not see how this would work and if would not rather have (also) to run borgmatic from cron given my use case.

Would I need two distinct lines in the crontab (https://projects.torsion.org/borgmatic-collective/borgmatic/src/branch/master/sample/cron/borgmatic) with e.g.

# once a day
0 3 * * * root PATH=$PATH:/usr/bin:/usr/local/bin /root/.local/bin/borgmatic --verbosity -1 --syslog-verbosity 1 --config /etc/borgmatic.d/www.yaml

# every hour
0 * * * * root PATH=$PATH:/usr/bin:/usr/local/bin /root/.local/bin/borgmatic --verbosity -1 --syslog-verbosity 1 --config /etc/borgmatic.d/mysql-dump.yaml

The docs only explain the retention but I fail to see how this would work without having different execution times for borgmatic with cron. Or can I achieve the same just with having two different config files? I am puzzled 🙃

I want ot backup `/var/www/` once a day (at night) but the mysql DB on the same server every hour to borgbase. So after reading https://torsion.org/borgmatic/docs/how-to/make-per-application-backups/ it seems like I have to create two almost identical config files. Fine. Still, I do not see how this would work and if would not rather have (also) to run `borgmatic` from cron given my use case. Would I need two distinct lines in the crontab (https://projects.torsion.org/borgmatic-collective/borgmatic/src/branch/master/sample/cron/borgmatic) with e.g. ```sh # once a day 0 3 * * * root PATH=$PATH:/usr/bin:/usr/local/bin /root/.local/bin/borgmatic --verbosity -1 --syslog-verbosity 1 --config /etc/borgmatic.d/www.yaml # every hour 0 * * * * root PATH=$PATH:/usr/bin:/usr/local/bin /root/.local/bin/borgmatic --verbosity -1 --syslog-verbosity 1 --config /etc/borgmatic.d/mysql-dump.yaml ``` The docs only explain the retention but I fail to see how this would work without having different execution times for borgmatic with cron. Or can I achieve the same just with having two different config files? I am puzzled 🙃

witten commented

2022-03-17 21:56:10 +00:00

Would I need two distinct lines in the crontab

That's correct. borgmatic doesn't handle scheduling itself, so if you have scheduling needs, you'll need to use an external tool like cron or systemd. And if you have two distinct scheduling needs, then you'll need two separate entries in cron (or systemd) as per your example. And that does mean two separate borgmatic configurations.

Does that answer your questions, or did I miss something?

> Would I need two distinct lines in the crontab That's correct. borgmatic doesn't handle scheduling itself, so if you have scheduling needs, you'll need to use an external tool like cron or systemd. And if you have *two* distinct scheduling needs, then you'll need two separate entries in cron (or systemd) as per your example. And that does mean two separate borgmatic configurations. Does that answer your questions, or did I miss something?

witten added the

question / support

label 2022-03-17 21:56:17 +00:00

gerdneuman commented

2022-03-19 10:10:45 +00:00

I see. Thanks for clarifying. (Maybe the need for calling differently via cron could be mentioned in the docs though.)

👍 1

witten commented

2022-04-28 18:04:26 +00:00

it seems like I have to create two almost identical config files

This is no longer the case! As of borgmatic 1.6.0, you can easily share common configuration among separate borgmatic configuration files. See the documentation on include merging for details.

> it seems like I have to create two almost identical config files This is no longer the case! As of borgmatic 1.6.0, you can easily share common configuration among separate borgmatic configuration files. See [the documentation on include merging](https://torsion.org/borgmatic/docs/how-to/make-per-application-backups/#include-merging) for details.

witten referenced this issue from a commit

2022-04-28 18:17:04 +00:00

Add mention in documentation about multiple backup scheduling needs (#511).

witten closed this issue

2022-04-28 18:17:14 +00:00

Sign in to join this conversation.