When I go back to V3.9 and "Database A", then I will lost datas for two 
weeks.
So now I leave everything and live with a much smaller data gap.

I expressed myself unhappily regarding the new database. 
I meant the new database now has over 100 tables and an alphabetical order 
compared to the previous.

Joachim

Am Mittwoch, 13. Mai 2020 21:39:46 UTC+2 schrieb Tom Keffer:
>
> 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] 
> <javascript:>> 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] <javascript:>.
>> 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>
>> .
>>
>
Am Mittwoch, 13. Mai 2020 21:39:46 UTC+2 schrieb Tom Keffer:
>
> 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] 
> <javascript:>> 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] <javascript:>.
>> 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/11cd0ba3-c902-48e9-8384-402c7d77b89b%40googlegroups.com.

Reply via email to