Lots of people have mentioned rsynx, restic, borgbackup, and others, but which would be best for backing up nextcloud, immich, and radicale? Do all of them have a method of automatically backing up every X days/weeks? Why use one over the other, what are the differences?

  • PlutoniumAcid@lemmy.world
    link
    fedilink
    English
    arrow-up
    4
    ·
    23 hours ago

    Simple file copying is easy and smart.

    What do you do about databases? I’m guessing you are running some containers that have a database, like paperless and many others.

    • Lem453@lemmy.ca
      link
      fedilink
      English
      arrow-up
      1
      ·
      edit-2
      3 hours ago

      I use a docker container that uses the MySQL/postgress dump command to create database dumps every hour with a retention policy. The dump is placed into docker data directory.

      My docker data directories are in a parent directory on the host.

      Borgbackup then runs the backup on this one directory. Like the other reply mentions, this is probably overkill since the database doesn’t isn’t being written too that intensivley but the resources needed to do this are minimal so its not a big deal once you know how to set it up.

      https://github.com/Martlark/pg_dump

      https://github.com/fradelg/docker-mysql-cron-backup

    • drkt@scribe.disroot.org
      link
      fedilink
      English
      arrow-up
      3
      ·
      23 hours ago

      I’m not backing up any databases that are so intensively used that I can’t live-copy them. Most of my databases (SQLite) sit idle until I explicitly do something to them. SQLite doesn’t really care about it unless it’s actively writing to the database.

      • WhatAmLemmy@lemmy.world
        link
        fedilink
        English
        arrow-up
        2
        ·
        edit-2
        21 hours ago

        This is why I switched everything to single disk ZFS. The ability to snapshot everything with zero downtime, including data in case I ever misconfig something, as well as replicate all of it to other ZFS drives offsite in the most efficient way possible — including encrypted data without transferring the keys — was a no brainier.

        It isn’t a full backup strategy, but it has enables features that no other backup software can do anywhere near as easily or efficiently.

    • confusedpuppy@lemmy.dbzer0.com
      link
      fedilink
      English
      arrow-up
      2
      ·
      23 hours ago

      Container databases seem as simple as shutting down a container, running a backup and then starting the container again. Although my my experience is only from hosting a Lemmy/PieFed instance. I did make many backups and restores with no issues to the database. It all worked as I intended it to work.

      I would imagine a similar process for non container databases. Stop, backup, restart. Although someone with more experience would be better to answer that.