Thanks for the quick reply. I think I understand what you're saying, but I've no idea how to do this in practice. I know I have a lot to learn about all this stuff, but at my time of life it doesn't get any easier. I can manage simple Linux or Python stuff, but I'm really in the dark when it comes to databases.
I only have a few days of new data. If I just deleted the new weewx.sdb (in /var/lib/weewx) and replaced it with the old one, would that work if I accept the loss of the last few days. The original Weewx was v2.6 , would the format of the old file be the same as required by the latest version of Weewx? On Monday, 13 January 2020 17:58:48 UTC-4, vince wrote: > > On Monday, January 13, 2020 at 1:40:47 PM UTC-8, Derek Hodge wrote: > >> The new system is running fine and storing data in weewx.sdb >> >> I have a copy of the old weewx.sdb file with almost 3 years of data (103 >> MB). >> >> My question is:- >> >> What's the easiest way for a database novice to join these two files, so >> that I can display all the data I have? There will be a few weeks gap where >> I was rebuilding the system but that's OK. >> Also will stats.sdb automatically regenerate after the databases are >> joined? >> >> >> > Personally I'd do the following.... > > - run a sqlite3 dump on the old file to an output file > - restore that file into your new database, it should do the right > thing > > (working off copies of all files of course) > > > -- 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/432a5068-8d95-4c50-b474-30a7c377768f%40googlegroups.com.
