On 29/07/2022, Guido Cioni wrote: > From what I understand weewx uses sqlite because of the default, and with > sqlite the only possibility is to dump the whole database every time > (https://github.com/glennmckechnie/weewx-sqlbackup/wiki/SQLBackup-README), > which is obviously time consuming.
Looks like the author (me) forgot to add a note to that section of the README. I'd better go and sync the sqlbackupREADME.html with the github README.md ! The extension was modified to also do partial backups of the sqlite database. So in that respect there is, now, no difference between Mysql / MariaDB and sqlite when using this skin. The skin.conf does default to partial sqlite backup and has comments in that file regarding changing those settings. I wrote this to scratch an itch. I wanted it all handled by weewx, and to run during a time when no writes were occuring. The weewx report cycle is perfect for that; providing we don't ask weewx to handle too much extra, in which case the reports may be delayed. I've done full database backups using this skin and it works... for me. I do that on a occasional basis (by using Report_timing on another, uniquely named instance) so that there is an updated, more recent baseline to start the recovery from. That means I interfere with report generation during that time, but it recovers. Mine was set to daily (the default), it now only does weekly (because I have a replicated, off site, mysql database.) It runs seamlessly with those settings. YMMV. The recovery using sqldump files is a laborious process, but it's covered in the sqlbackupREADME.html and it worked when I wrote those notes. Anyone that uses this skin needs to test the recovery process themselves, as you would for ANY backup method. Like I said. This scratched my itch. There's an abundance of other methods. If you do find a problem with this method, one that needs fixing - then let me know. -- Cheers Glenn rorpi - read only raspberry pi & various weewx addons github.com/glennmckechnie -- 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/CAAraAzjixeNbiS_hnwhAN48jeK_yAiVFhOp1mKJr0D7XZXODPw%40mail.gmail.com.
