Am Donnerstag, 23. Januar 2020 02:55:50 UTC+1 schrieb gjr80:
>
> Hallo Georg,
>
> When i saw *Mittwoch* in your reply I thought then that you should look 
> at that thread from early January, it has both English and German, well 
> Google-German!
>
> The readonly database issue is a sure sign that the user account that you 
> are executing the sqlite3 command from does not have sufficient privileges 
> to write to the database file. When you run the sqlite3 command try 
> prefixing it with sudo. So step 5 would be something like this:
>
> $ sudo sqlite3 /var/lib/weewx/weewx.sdb
> sqlite> .read /var/tmp/old.dump
>
> Gary
>
> On Thursday, 23 January 2020 10:11:49 UTC+10, weerman wrote:
>>
>>
>>
>> Am Mittwoch, 22. Januar 2020 21:32:00 UTC+1 schrieb gjr80:
>>>
>>> A search of the group for ‘merge databases’ will throw up a few threads 
>>> that cover merging databases including the detailed commands to use. 
>>>
>>> Gary
>>
>>
>> Thanks a lot Gary, found and followed a useful one. 
>>
>> https://groups.google.com/forum/#!searchin/weewx-user/merge$20databases%7Csort:date/weewx-user/86KPd-dyvD4/4eOtUDN5BgAJ
>>
>> However i'm stuck at step 5. 
>> sqlite3 /var/lib/weewx/weewx.sdb
>> sqlite> .read /var/tmp/old.dump (i renamed the old weewx database into 
>> "old.db") 
>> After i entered the latter command, i got an error message "near line XY: 
>> attempt to write a readonly database" for every single line.
>> I have over one million lines in the old database... has it something to 
>> do with that error?
>> Also made sure that weewx isn't running.
>>
>> Georg
>>
>>
>> Hallo Gary,
>>
>
Thanks a lot for your help, that fixed the problem. 


Beste Grüße / Best Regards

Georg



-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/weewx-user/2ae71eca-46d7-4736-a215-7703ec1ee22b%40googlegroups.com.

Reply via email to