Thx for answering, I did following after long search.... Copy from old instance to the new installed 4.3.x version. Then wee_database weewx.conf --reconfigure replace _new db to orig name.... Restart and rebuilt daily summary take ~1 houre for 500000 records now it's migrated to new schema so for future features releases.
br [email protected] schrieb am Freitag, 22. Januar 2021 um 14:56:14 UTC+1: > The schema is used only when you create a new database. WIth old > databases, the schema is read directly from the database. So, you can just > copy your old database to the new installation. WeeWX will continue to work. > > If you want to *change* schemas, that's something different, but there is > no reason to do so unless you want to take advantage of the new types. > > -tk > > On Fri, Jan 22, 2021 at 1:33 AM Manfred Nadymacek <[email protected]> > wrote: > >> Hi all, >> My problem is following: >> I run since 4,5 years my weewx station hosted on a raspberry pi. >> I start 2016 with a prober version and update it to latest 3.9 version. >> >> Now I reinstall a new raspberry Pi with lastest raspian version and >> weewx 4.3 and do also all new configuration and add new skins aso... >> >> BUT: I found out that the old version has following Databinding: >> [DataBindings] >> >> [[wx_binding]] >> # The database must match one of the sections in [Databases]. >> # This is likely to be the only option you would want to change. >> database = archive_sqlite >> # The name of the table within the database >> table_name = archive >> # The manager handles aggregation of data for historical summaries >> manager = weewx.wxmanager.WXDaySummaryManager >> # The schema defines the structure of the database. >> # It is *only* used when the database is created. >> schema = schemas.wview.schema >> >> >> And in the new config has already the new extrended schema: >> [DataBindings] >> >> [[wx_binding]] >> # The database must match one of the sections in [Databases]. >> # This is likely to be the only option you would want to change. >> database = archive_sqlite >> # The name of the table within the database >> table_name = archive >> # The manager handles aggregation of data for historical summaries >> manager = weewx.manager.DaySummaryManager >> # The schema defines the structure of the database. >> # It is *only* used when the database is created. >> schema = schemas.wview_extended.schema >> >> My idea would be i will shutdown the old weewx instance and copy the old >> database to the correct folder in the new installed weewx version. >> BUT i guess that will not work and my fear is the old data are lost or >> not visible. >> >> CAN anybody help me to migrate the old sqlite database to the new 4.x >> schema standard without lost my history data?? >> >> Thx very much! >> Manfred >> >> >> >> -- >> 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/8d31bb56-0b2c-4e77-956b-57decefd4cf3n%40googlegroups.com >> >> <https://groups.google.com/d/msgid/weewx-user/8d31bb56-0b2c-4e77-956b-57decefd4cf3n%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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/4943a2fd-cdb7-4f43-9d17-a466d743b7adn%40googlegroups.com.
