17
Question about backup
(derpzilla.net)
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
this post was submitted on 12 Aug 2023
17 points (94.7% liked)
Selfhosted
40134 readers
291 users here now
A place to share alternatives to popular online services that can be self-hosted without giving up privacy or locking you into a service you don't control.
Rules:
-
Be civil: we're here to support and learn from one another. Insults won't be tolerated. Flame wars are frowned upon.
-
No spam posting.
-
Posts have to be centered around self-hosting. There are other communities for discussing hardware or home computing. If it's not obvious why your post topic revolves around selfhosting, please include details to make it clear.
-
Don't duplicate the full text of your blog or github here. Just post the link for folks to click.
-
Submission headline should match the article title (don’t cherry-pick information from the title to fit your agenda).
-
No trolling.
Resources:
- selfh.st Newsletter and index of selfhosted software and apps
- awesome-selfhosted software
- awesome-sysadmin resources
- Self-Hosted Podcast from Jupiter Broadcasting
Any issues on the community? Report it using the report flag.
Questions? DM the mods!
founded 1 year ago
MODERATORS
Personally I would create one borg repo for every server I backup. But I also use borgbase, which encourages that by default.
About the backup of the datase - use mysqldump and store that. You can also do it like this:
The
-tells borg to use stdin as the content you want to store.Lastly there is a pull mode in borg, that way you could run one script on one host to backup all your servers. You would need to run mysqldump over ssh then.
Edit:
You can use one repo for all servers, make sure to use prefixes, so that you can use
--glob-archiveswithborg prune, if not you might get old backups cleaned out that you want to keep.Thanks pull mode is exactly what I was looking for!