Well...space and bandwidth may be an issue in remote installations, like the one that I have, where everything get through a metered connection. That's why I'm trying to find a way to transmit only the data that I have to transmit every time to backup: this way I could backup more frequently. Imagine sending a 400 MB file every hour through a connection that has a 4 GB monthly cap :) Even if it's compressed I still don't see the reason to send the entire db every time just because "it's easy and disk is cheap".
About cron: it's not like that I don't want to use it, but I'm trying to find a solution that will work inside weewx directly so that it's more portable. I have already other processes running in cron and it would be easier to manage it if it's handled by weewx directly. Anyway, thanks for the input. On Thursday, July 28, 2022 at 9:08:11 PM UTC+2 [email protected] wrote: > On Thursday, July 28, 2022 at 7:35:48 AM UTC-7 [email protected] wrote: > >> What I'm trying to avoid is having to transfer the whole database dump >> every time that a backup is performed, because that can become demanding >> when the archive grows for many years: I have another station running a >> similar DB and after more than 10 years the full DB has become about 400 MB >> in size... >> >> > Ummm - so what if it's 400MB in size these days ? Disk is cheap and your > old archives aren't worth much to you anyway after your datalogger runs out > of space anyway. Just keep the last few and gzip them before saving. > > My weewx.sdb is 393 MB but it gzips down to 84 MB. That's nothing these > days. > > I do the same thing Doug mentioned for mysql, but I use the default > sqlite3 db for simplicity reaons. > > You're jumping to a solution, looking for a way to backup only diffs > (why?) without using cron (again, why?) when you really have no problem to > begin with. Just dump your db and compress the result. Check your backups > for being good for restores too. There are lots of threads in the > weewx-user group with links to code folks have written to do that. > > -- You received this message because you are subscribed to the Google Groups "weewx-development" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-development/5bdf1517-b065-484b-a8a9-0fbf7e7bdb58n%40googlegroups.com.
