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.