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 <nady2...@gmail.com> 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 > > tke...@gmail.com 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 <nady...@gmail.com> >> 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 weewx-user+...@googlegroups.com. >>> 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 weewx-user+unsubscr...@googlegroups.com. > 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 weewx-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CAPq0zECsb04ntetCpLiqZn1cRhM8fe-JMSWb-pR5ikZjzzeMSw%40mail.gmail.com.
