Be aware that doing it like this, the traffic from the VPS to your home will be unencrypted.

I would have, but this is all about the power consumption. Getting an old PC, I’m afraid to be at least around 100W…

Oh? This is weird, I have disabled transcoding on my rpi and I have some files that won’t play or the subtitles won’t load. I’m playing from my local network on an AndroidTV. I thought this was a file format issue and that transcoding would solve the issue

I see, thank you.

For now I went with the cron dump and the rclone. The only issue with this setup is that I can’t monitor the database dump easily. Thus, if the dump fails, borg will just backup the failed dump…

As for the VPS, of course, ideally, it’s secured enough. But as it is said, if the server is exposed to the Internet you cannot be sure of anything…

I was talking about this: https://torsion.org/borgmatic/docs/how-to/backup-your-databases/

If you’re using MariaDB, use the MariaDB database hook instead of mysql_databases: as the MariaDB hook calls native MariaDB commands instead of the deprecated MySQL ones.

But I guess this is basically a mysql dump reading from stdin

Thanks pull mode is exactly what I was looking for!

Thanks for the clarification about the repositories!

If I understood correctly, I should run a cron on the VPN that dumps the DB and encrypts it. Then borg only has to get the dump and archives it.

Also what is the reason not to use the mariadb tool provided by borg? It looked interesting because of the data stream.

Thanks, indeed, restic looks interesting!

For now I don’t have much use for the deduplication as every servers are hosting different data.

One drawback I can see is the memory usage. My raspberry only has 2GB I’m not sure if this is going to be an issue. Currently the data I need to back up are around 100GB.

Checked with my old basic calculator, the answer is indeed 16 😂

deleted by creator