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/fdcd376d-2c68-4da9-a1e5-d5c4347c50ac%40googlegroups.com.
