On 18 July 2017 at 11:28, Stefano Rossi <[email protected]> wrote:

> Thanks for your answer!
>

That's alright.

Given you lost 3 years of data, and not to give you false hope, but are you
sure it's actually gone?  Just because the pi won't boot up doesn't mean
it's not there, and if it is it might (long shot) be okay; or not, but
you've got to check! You might be lucky. Have you checked the card from a
card reader?



> [...]
>
> The second one, I can't make the first bk...
>
>
>> Are you using mysql or sqlite ?
>>
>
> I don't know, I have to check this... but I use a standard installation of
> weewx, nothing changed.
>
>
>> I'm guessing you're using a raspberry pi? I'm also guessing it was a deb
>> install, not via setup.py? (File location will be different for each)
>>
>
> Correct, I'm using a raspberry pi with a Jessie distribution. The
> istallation was done via setup.py (I followed an end to end guide made by
> an italian guy that I found on internet).
>

Sounds like it's an sqlite database (default install) and I believe that
can be found in
 /home/weewx/archive as weewx.sdb.

An sqlite database can be backed up by simply copying it.

>From a terminal

sudo cp /home/weewx/archive/weewx.sdb copyofweewx.sdb

(that will make a copy in the same directory as you are in, change as
required)

The result can be checked with

sudo echo 'pragma integrity_check;' | sqlite3 copyofweewx.sdb which should
return just 2 letters - ok

If you don't get ok, just try copying it again. Failing that stop weewx and
try again, or use it to test if the original database is okay.


>
>
>
>> > if I had to create a scheduled script to do a backup I need a guide
>> > end to end to do that... like all the passages..
>>
>
>
>> Did you see the recent link I posted
>> https://groups.google.com/forum/#!topic/weewx-user/O2Y4h4xzNEE
>> as that will create the sql text backups for you, although you do need to
>> do some manual steps to restore them.
>>
>
> Yes I saw that, but I don't know how I can use that...
>

Okay... The instructions are on the github README.md. If you were able to
walk through the installation of the original weewx, you will be able to
follow them and succeed with sqlbackup - it's just a skin and it installs
using the weewx tools. The defaults work even thought they may be a bit...
regular? (daily) ie; once installed and weewx is restarted you'll have
daily backups in /var/backups, and all that can be changed from the
skin.conf file, as with any of the skins.


Your english is fine from my end. Is it a problem reading and translating
english instructions, or is it that linux and the command line is just one
hurdle too many?


Cheers
 Glenn

rorpi - read only raspberry pi + weewx: now with scripts
<https://github.com/glennmckechnie/rorpi-raspberrypi>

-- 
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].
For more options, visit https://groups.google.com/d/optout.

Reply via email to