Heavens. You are making this way more complicated than necessary. There is no "V4.0 database" --- the database has not changed. The only new thing is the opportunity to use an extended schema. But, if the original "wview" schema is working fine for you, don't do anything.
1. Go back to your original "Database A". Get rid of the rest. 2. Go back to your original V3.9 setup. Get rid of the rest. 3. Do a simple upgrade as you always have: *sudo apt-get updatesudo apt-get install weewx* 4. Then install the Belchertown skin. Now you're running on WeeWX V4 with Python 2. 5. If you do want to use the extended schema, perhaps because you have some new sensors that can take advantage of the extended schema, follow the directions I gave in this post <https://groups.google.com/d/msg/weewx-user/KUoo_FZW9v4/lnbFOE74AwAJ>. Otherwise, don't do it. 6. If you want to change to Python 3, then you'll have to switch repositories. Assuming a Debian 10 system, follow the directions here <http://www.weewx.com/docs/debian.htm>. If you have a Debian 9 system, it's more complicated, and we recommend staying with Python 2. On Wed, May 13, 2020 at 10:05 AM Joachim Puttkammer <[email protected]> wrote: > I will briefly describe what I have done. > 1. weewx database saved (mysqldump) > 2. update from 3.9 to 4.0 > 3. Installed Belchertown skin and found that there are problems with the > NOAA reports > 4. 4.0 completely uninstalled (all weewx files, folders and database) and > reinstalled, and transferred the all backed up settings. > 5. Did not remember that the weewx.conf 3.9 has the entry 'target_unit = > METRICWX'. With the 4.0 it says 'US'. After days database saved and weewx > database deleted. 'target_unit' changed back to METRICWX. > > Conclusion: > 1 Database A with METRICWX and old structure 3.9 > 1 Database B with METRICWX and new structure 4.0 > 1 Database C with US and new structure 4.0 > I imported the METRICWX Database A with a php script into Database B. Now > I want to import Database C as well, but how? > > I want to keep the structure of the 4.0 Database. > > greetings > Joachim > > > > Am Montag, 11. Mai 2020 13:06:09 UTC+2 schrieb Graham Eddy: >> >> unless you are using features of the new database, you can simply >> continue using the old database (no unload/reload - keeping a copy of old >> database before using it with updated weewx, of course). >> g-eddy >> >> On 11 May 2020, at 8:53 pm, Joachim Puttkammer <[email protected]> >> wrote: >> >> Hi all, >> I have reinstalled weewx 4.0 and now I want to import the old mysql DB >> (weewx 3.9). Unfortunately there is a problem with the import, because the >> old archive table has 52 columns and the new one has 114 columns. >> >> >> >> >> -- > 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/778a347a-b25a-40ec-80af-9273debad5bd%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/778a347a-b25a-40ec-80af-9273debad5bd%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/CAPq0zEBvpxxTjek-Dv0dfXdxfMZJ9Be5CCqJPfNgENGM_wx4Tw%40mail.gmail.com.
