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/CAPq0zED8pEJt1Waw2SEQHWVe_PY8LPQV10DkAY5AZ%3De%2BBj9wdw%40mail.gmail.com.
