SQLite has its own backup function https://www.sqlite.org/backup.html
Use .backup when:

   - the database may be in use,
   - you want a reliable copy,
   - you want to avoid corrupt backups.

It is the recommended SQLite-safe approach for making backups of live 
databases.

On Thursday, February 20, 2025 at 6:29:14 AM UTC-6 Keimpe Bleeker wrote:

>
> Thanks for the responses and I learned again!
> It seems good to me to make the weekly small backup with Weewx-live on 
> Saturday 01h07min and to stop Weewx for the monthly image backup.
>
> Regards, Keimpe
>
> Op ma 17 feb 2025 om 20:07 schreef vince <[email protected]>:
>
>> I copy the db to a different directory then compress the copy. Very safe 
>> and reliable.
>>
>> On Monday, February 17, 2025 at 10:00:26 AM UTC-8 p q wrote:
>>
>>> It's not necessary to shut down weewx for the weekly backup. The 
>>> database is the only thing being written to and if you're accessing it 
>>> won't be written to. However, I do stop weewx for my daily backup just to 
>>> be sure, but it doesn't take very long. I stop weewx just long enough to 
>>> make a local copy of the db and then restart it before copying the copy off 
>>> site.
>>>
>>> I have no idea what happens when you make an image of a running SD card.
>>>
>>> On Mon, Feb 17, 2025 at 9:34 AM Keimpe Bleeker <[email protected]> 
>>> wrote:
>>>
>>>> Hi all, once a week a script, executed by CRON, is making a backup of 
>>>> the essentials like config files and the weewx.sdb, once a month an image 
>>>> of the SD-card. Prior to these backups I'm stopping Weewx, in my point of 
>>>> view to protect the database. The 'small backup' takes some minutes, the 
>>>> image about half an hour.  I'm curious if it is necesarry to shut down 
>>>> Weewx. Anobody a suggestion?     
>>>>
>>>> -- 
>>>>
>>> You received this message because you are subscribed to the Google 
>>>> Groups "weewx-user" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send 
>>>> an email to [email protected].
>>>> To view this discussion visit 
>>>> https://groups.google.com/d/msgid/weewx-user/c84a0352-0b36-4e93-a78b-5fee18989600n%40googlegroups.com
>>>>  
>>>> <https://groups.google.com/d/msgid/weewx-user/c84a0352-0b36-4e93-a78b-5fee18989600n%40googlegroups.com?utm_medium=email&utm_source=footer>
>>>> .
>>>>
>>>
>>>
>>> -- 
>>> Peter Quinn
>>> (415)794-2264 <(415)%20794-2264>
>>>
>> -- 
>>
> You received this message because you are subscribed to a topic in the 
>> Google Groups "weewx-user" group.
>> To unsubscribe from this topic, visit 
>> https://groups.google.com/d/topic/weewx-user/I2q3gPszItk/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to 
>> [email protected].
>> To view this discussion visit 
>> https://groups.google.com/d/msgid/weewx-user/328665b8-4799-4c74-83ce-ea37b01fda19n%40googlegroups.com
>>  
>> <https://groups.google.com/d/msgid/weewx-user/328665b8-4799-4c74-83ce-ea37b01fda19n%40googlegroups.com?utm_medium=email&utm_source=footer>
>> .
>>
>

-- 
You received this message because you are subscribed to the Google Groups 
"weewx-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To view this discussion visit 
https://groups.google.com/d/msgid/weewx-user/76bfa849-0bfa-4746-9a5e-06d821d6cd04n%40googlegroups.com.

Reply via email to