Yes, I'm pretty sure if you copied the old database file in place of the new one it would start adding to it. I would for sure keep a backup of the file before doing so.
On Mon, Jan 13, 2020 at 3:54 PM Derek Hodge <[email protected]> wrote: > 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 > <https://groups.google.com/d/msgid/weewx-user/432a5068-8d95-4c50-b474-30a7c377768f%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- Peter Quinn (415)794-2264 -- 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/CAA1SM23HBQL-FK_L1U1c5ERyzSSkSQHJtHs018YhoOPPgtd9yQ%40mail.gmail.com.
