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 > > > > > -- 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 on the web visit https://groups.google.com/d/msgid/weewx-user/bf8b4f28-b9b7-4949-8e56-a7f01ef31ba0%40googlegroups.com.
