I run this once a day via cron on my observium system:
#!/bin/bash mysqldump --databases observium --add-drop-table --extended-insert > observium-dump.sql tar zcf observium-rrd.tar.gz /opt/observium/rrd
A few hours later, on a backup server, I have cron pull a copy of these two files and the config.php. It would be just as easy to add a few additional lines to this script to push copy in the other direction (from observium to backup server) I guess, but I find it easier to rotate backups on my backup server the other way.
I use a .my.conf file to store the database credentials to avoid having to enter an interactive password.
From: observium observium-bounces@observium.org on behalf of Terry Stone via observium observium@observium.org Date: Thursday, April 29, 2021 at 2:04 PM To: observium@observium.org observium@observium.org Cc: Terry Stone terry@beach-works.com Subject: [EXT] [Observium] Wish list Rather than re-invent the wheel writing a script does anyone have a script that can be run as a con job to backup rrd files, observium database and config.php to an external server.
Thanks.