Question regarding new 4.x schema

[Manfred Nadymacek]

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

[Tom Keffer]

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

--
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.

[Manfred Nadymacek]

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

[Tom Keffer]

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.

To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/4943a2fd-cdb7-4f43-9d17-a466d743b7adn%40googlegroups.com.

[Manfred Nadymacek]

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

To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CAPq0zECsb04ntetCpLiqZn1cRhM8fe-JMSWb-pR5ikZjzzeMSw%40mail.gmail.com.

[Tom Keffer]

If you leave it alone, either will work just fine. 

To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CALNFVshku0866g8VUuYg6VTeHLHoedUU%2BJQa7XzrgssNusE4fA%40mail.gmail.com.

[Manfred Nadymacek]

thx good to know for next time migration.

To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CAPq0zEBFw7Gy9m8jbqO695Us_jwhrvbJ9HT1x2hvXrjavP7HUQ%40mail.gmail.com.