thx good to know for next time migration.
Am Fr., 22. Jan. 2021 um 19:28 Uhr schrieb Tom Keffer <[email protected]>: > If you leave it alone, either will work just fine. > > On Fri, Jan 22, 2021 at 10:23 AM Manfred Nadymacek <[email protected]> > wrote: > >> i was confused because this ! >> Default in 4.3 : >> [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 >> >> and on my old instance 3.9.x: >> [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 >> >> >> My fear as i said is that only copy cannot work with it... It't not >> written in the docs... >> >> br >> >> Am Fr., 22. Jan. 2021 um 19:06 Uhr schrieb Tom Keffer <[email protected] >> >: >> >>> Well done, but, as I said, there is no reason to migrate to the new >>> schema unless you intend to take advantage of the new database types. >>> >>> On Fri, Jan 22, 2021 at 9:58 AM Manfred Nadymacek <[email protected]> >>> wrote: >>> >>>> 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 >>>> <https://groups.google.com/d/msgid/weewx-user/4943a2fd-cdb7-4f43-9d17-a466d743b7adn%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/CAPq0zECsb04ntetCpLiqZn1cRhM8fe-JMSWb-pR5ikZjzzeMSw%40mail.gmail.com >>> <https://groups.google.com/d/msgid/weewx-user/CAPq0zECsb04ntetCpLiqZn1cRhM8fe-JMSWb-pR5ikZjzzeMSw%40mail.gmail.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/CALNFVshku0866g8VUuYg6VTeHLHoedUU%2BJQa7XzrgssNusE4fA%40mail.gmail.com >> <https://groups.google.com/d/msgid/weewx-user/CALNFVshku0866g8VUuYg6VTeHLHoedUU%2BJQa7XzrgssNusE4fA%40mail.gmail.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/CAPq0zEBFw7Gy9m8jbqO695Us_jwhrvbJ9HT1x2hvXrjavP7HUQ%40mail.gmail.com > <https://groups.google.com/d/msgid/weewx-user/CAPq0zEBFw7Gy9m8jbqO695Us_jwhrvbJ9HT1x2hvXrjavP7HUQ%40mail.gmail.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/CALNFVsijuZYWV6t%2B%3DAqDAd8%2Bmrza_jEcZV6gtXZCNacefjik-Q%40mail.gmail.com.
