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.
