My apologies, but I'm just not following this. There is no "upgrading" of the database. They are all the same. You can take a database from wview 15 years ago, and run it on a modern WeeWX with no changes.
Now it's true that the *default* schema for WeeWX changed in V4.0 from the "wview" schema to the "wview-extended" schema, but old schemas will run without change. Simply move the old database into place --- no need to "import" it. Perhaps I'm missing some subtlety here, but I keep seeing this. *There is no need to "upgrade" your database!* Just use it. On Mon, May 2, 2022 at 6:33 AM Burns Fisher <bu...@fisher.cc> wrote: > I've been a WeeWX user since late 2013. At first I ported it to a > BeagleBone Black but I moved it to a Raspberry Pi somewhere around late > 2018. The point of all this is that I have been running it for years--last > version was 3.8.0, I think, but just this weekend I actually upgraded the > whole Pi to the latest Raspbian as well as WeeWX 4.8. I appreciate that > WeeWX can upgrade the database files automagically, but just like the > original poster here, I am stuck with an old database that I'd like to > import. > > The Raspberry Pi folks have a tendency to say "Yes, you can upgrade > Raspbian, but it is much easier to just install the new version fresh" (and > this is my experience in other cases too!). This precludes upgrading WeeWX > and thus the database does not automatically get upgraded. I found this > post after I had already installed the new system and it had been running > for a day or so (without any old data). It turns out that the > "reconfigure" above was just what I needed. I stopped WeeWX, made a copy > of the day-old database and replaced it with the old one. Then ran > re-configure and rebuilt the daily summaries (must use "sudo"!) and > started up WeeWX. Interestingly, WeeWX must have had to rebuild some more > because it was not till I looked this morning that a whole year's worth of > data was showing under "Year". But the other interesting thing is that it > apparently re-downloaded data from my Vantage's buffer so it seems to have > all the data from the past couple days and I don't have to merge in the > "new" database. > > Anyway, besides giving my experience, I'd like to suggest that idea that > an upgrade on Raspberry Pi might often consist of a complete new system be > included in the documentation. Then also mention 'reconfigure'. The only > hard part about this was finding the information! Thanks to everyone for > it being here at all! > > Thanks for listening... > > Burns > > On Monday, April 25, 2022 at 5:30:05 AM UTC-4 Meteo Oberwallis wrote: > >> The old schema was >> "schema=user.radiationhours.schema_with_sunshine_hours". If I load my old >> weewx.sdb and then configure it with "wee_database weewx.conf >> --reconfigure" then this deletes the "sunshine_hours" column. All other >> data will be accepted. I'll try your instructions to see if it works. >> Thanks very much >> >> vince schrieb am Sonntag, 24. April 2022 um 21:55:37 UTC+2: >> >>> I have no idea where sunshine_hours comes from. Did you add it to your >>> old weewx schema ? If so you'd need to similarly add it to the new schema >>> probably before doing your conversion and see if wee_database is smart >>> enough to do the right thing. >>> >>> (untested - but give it a try. This is why you always work off copies >>> of your data..). >>> >>> On Sunday, April 24, 2022 at 12:29:04 PM UTC-7 Meteo Oberwallis wrote: >>> >>>> Hello Vince Many thanks for your response. I moved my old weewx.sdb to >>>> the new weewx version and then created it in the new format with >>>> "wee_database weewx.conf --reconfigure". Unfortunately, the >>>> "sunshine_hours" was deleted in the process. Can I somehow transfer these >>>> to the new scheme? Greeting >>>> >>> -- > 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/89f57f3b-6aff-4de6-a55c-4df3bd9f5d38n%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/89f57f3b-6aff-4de6-a55c-4df3bd9f5d38n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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/CAPq0zECP8eLn%3DU%2Bhn9nKrUjsroEzEPyqVjMgBbLUJRR_X%2B-9EA%40mail.gmail.com.
