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/415fde80-b8bb-4847-ab4b-21766503bf5fn%40googlegroups.com.
