Thanks so much! I somehow got it up and running... Not exactly sure what I
did. Maybe just a restart again worked? I really appreciate the info!

On Sun, Apr 15, 2018 at 7:18 AM, David Hindley <dhind...@djhindley.com>
wrote:

> Gary
>
> Many Thanks. I will try this process.  My station is a Davis Vantage Pro 2
> with IP datalogger - does anyone know if this will allow weewx to
> "catch-up" if the weewx service has been stopped for a while for some
> database management, or will the records that would have normally been
> created in the downtime, be lost?
>
> David.
>
> On 15 April 2018 at 04:51, Glenn McKechnie <glenn.mckech...@gmail.com>
> wrote:
>
>> I note that you say that you know how to edit the database, so the
>> following points may appear to be redundant. But for the benefit for
>> someone reading this thread later, that may not have the same confidence as
>> yourself,  I'll include them anyway.
>>
>> > should I stop the weewx service, work on the database and then start
>> the weewx service again (it might take me anything between 10 mins and a
>> few hours to do this).
>>
>> If it's the default sqlite (weewx.sdb) database then you have no option.
>> If you start editing the live database you'll lock it and weewx will halt
>> all writes to it.
>> You say 10 minutes to an hour so you won't want that.
>> .
>> For others , that may or may not be a problem, but be aware of it.
>>
>> You can get away with copying the sqlite while weewx is running, try and
>> do it during the report cycle if you feel nervous (no writes, only reads).
>> If you want 100% surity then stop it, you'll have then removed another
>> potentional hiccup.
>>
>> You can dump a mysql database while it's running. You can also edit it on
>> the fly without getting into serious problems, but if you make a mistake???
>> See Rule #1 below.
>>
>> So
>> Unless you like living on the edge...
>> Rule #1 says to make a copy of the database.
>> Optional Rule #2 suggests to make another copy and work on that.
>>
>> When you've got the process down pat - ie: you're satisfied with what you
>> are doing and the results are good, then you can swap over the databases.
>> Or if a longtime has elapsed, make another copy, fix that with your
>> recently honed process and swap it back in (with fewer values missed.)
>> weewx will be stopped while you do all that.
>>
>> >  If I stop the service, will weewx automatically reload all the
>> database entries for the time period when it was stopped in the previous
>> step.
>>
>> Depends on the weather station. Some will catch up, others won't (or
>> can't)
>>
>> See if your station gets a mention in the online documentation or tell
>> the group what the station is and someone with more authority may be able
>> to answer that question. Mine can't
>>
>> If it won't, you can dump the pre-swap database, edit and extract the new
>> entries and insert them into the new copy , which shouldn't take too long -
>> even with the precautions outlined above.
>>
>>
>> Cheers
>>  Glenn
>>
>> rorpi - read only raspberry pi & various weewx addons
>> https://github.com/glennmckechnie
>>
>> On 15 April 2018 at 01:54, <dhind...@djhindley.com> wrote:
>>
>>> I am in the process of importing some data to the database and making
>>> some corrections to the data once imported.  I know how to do this, but am
>>> not sure what the best/recommended workflow process is.  For example:
>>>
>>> - should I stop the weewx service, work on the database and then start
>>> the weewx service again (it might take me anything between 10 mins and a
>>> few hours to do this).
>>>  - If I stop the service, will weewx automatically reload all the
>>> database entries for the time period when it was stopped in the previous
>>> step.
>>>
>>> Or, should I not bother stopping the service, and if so, will this cause
>>> any problems if I am working on the database whilst weewx is trying to save
>>> records to it?
>>>
>>> Any help/tips are appreciated.
>>>
>>> Thanks
>>>
>>> David.
>>>
>>> --
>>> 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 weewx-user+unsubscr...@googlegroups.com.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>> --
>> 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/to
>> pic/weewx-user/3EgxZ01zaKc/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to
>> weewx-user+unsubscr...@googlegroups.com.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> 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 weewx-user+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 weewx-user+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to