Re: [weewx-user] New Database weewx 4.0

[Greg from Oz]

Edited the backup from
Make a backup just in case
mysqldump -uroot -p weewx_new > weewx.sql
to
Make a backup just in case
mysqldump -uroot -p weewx > weewx.sql


On Tuesday, 26 May 2020 20:10:50 UTC+10, Greg from Oz wrote:
>
> Hi I thought I would upgrade the schema and I know that I don't have 
> but.
> I couldn't find any documentation on how to do this for *mysql*.
> I did it this way and it seems to work. I am using weewx 4.1
>
> stop weewx
> Make a backup just in case
> mysqldump -uroot -p weewx > weewx.sql
> Because --reconfigure database makes a database called weewx_new I had to 
> allow new permissions for the weewx uer
>  mysql -uroot -p 
>  GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON `weewx_new`.* TO 
> 'weewx'@'localhost'
>  exit mysql
>  add the line below to weewx.conf [[wx_binding]]
>  schema = schemas.wview_extended.schema
>  wee_database --reconfigure
>  mysqldump -uroot -p weewx_new > weewx_new.sql
>  the line below is the only way to rename the database
>  mysql -uroot -p weewx < weewx_new.sql
>  delete the weewx_new database
> start weewx and cross your fingers.
>
> I don't know if this is the correct way to do this or if there is 
> documentation somewhere else but it works.
>
> On Friday, 22 May 2020 21:20:31 UTC+10, Tom Keffer wrote:
>>
>> WeeWX Version 4 introduces a new, more flexible, way of specifying 
>> schemas. The old way is still supported. If I understand you correctly, 
>> you're trying to use the new way on an old copy of WeeWX.
>>
>> Try upgrading WeeWX, then try again.
>>
>> -tk
>>
>> On Thu, May 21, 2020 at 9:26 PM Echo 7 Foxtrot <
>> michael...@echo7foxtrot.com> wrote:
>>
>>> I'm very new...been running my weewx 3.9.2 (rpi4) install for about a 
>>> month, using the standard wview.schema.  I've been working on adding some 
>>> sensors and wanting to extend the schema, then I saw the wview_extended 
>>> schema rolling out with 4.0.  It's got everything I wanted to add in the 
>>> near future, and if I'm going to add I thought it'd be best to stick to the 
>>> naming conventions chosen for 4.0.  I placed a copy of wview_extended.py 
>>> from 4.0 in /weewx/schemas and changed the schema in weewx.conf to 
>>> schemas.wview_extended.schema as mentioned in this thread.  This is what I 
>>> get:
>>>
>>> pi@raspberrypi:~ $ sudo wee_database /etc/weewx/weewx.conf --reconfigure
>>> Using configuration file /etc/weewx/weewx.conf
>>> Using database binding 'wx_binding', which is bound to database 
>>> 'archive_sqlite'
>>> New database 'weewx.sdb_new' already exists. Delete it first (y/n)? y
>>> Copying database 'weewx.sdb' to 'weewx.sdb_new'
>>> The new database will use the same unit system as the old ('US').
>>> Are you sure you wish to proceed (y/n)? y
>>> Traceback (most recent call last):
>>>   File "/usr/bin/wee_database", line 794, in 
>>> main()
>>>   File "/usr/bin/wee_database", line 156, in main
>>> reconfigMainDatabase(config_dict, db_binding)
>>>   File "/usr/bin/wee_database", line 336, in reconfigMainDatabase
>>> new_schema=manager_dict['schema'])
>>>   File "/usr/share/weewx/weewx/manager.py", line 817, in reconfig
>>> with Manager.open_with_create(new_db_dict, schema=new_schema) as 
>>> new_archive:
>>>   File "/usr/share/weewx/weewx/manager.py", line 141, in open_with_create
>>> dbmanager = cls(connection, table_name=table_name, schema=schema)
>>>   File "/usr/share/weewx/weewx/manager.py", line 82, in __init__
>>> self._initialize_database(schema)
>>>   File "/usr/share/weewx/weewx/manager.py", line 175, in 
>>> _initialize_database
>>> _sqltypestr = ', '.join(["`%s` %s" % _type for _type in schema])
>>> TypeError: not enough arguments for format string
>>>
>>> The _new .sdb file is created but it is empty (I did it again to capture 
>>> for this post, that's why it was already there).  I went to the syslog to 
>>> capture anything there for this post as well, but there were no entries 
>>> from attempting this.  This first time I tried it I stopped weewx first but 
>>> left it running when I ran wee_database the 2nd time...result was the same.
>>>
>>> Not sure what to do from here...I know just enough about python to have 
>>> a general idea of what the problem is but no idea how to digest this and 
>>> apply corrective action.  Thanks in advance for any help.
>>>
>>> -Michael F.
>>>
>>>
>>> On Saturday, May 9, 2020 at 6:57:09 AM UTC-5, Tom Keffer wrote:

 Updating to WeeWX V4 and changing your schema are two different things. 
 They have nothing to do with each other. Version 4 offers a new schema, 
 but 
 it is used only for new databases.

 If for some reason you wish to change schemas and use the new schema, 
 you can do so using either WeeWX V3 or V4. Follow the directions in the 
 section *Adding a new type to the database 
 * in the 
 Customizing Guide, except skip step #1, and in step #2 change this

Re: [weewx-user] New Database weewx 4.0

[Greg from Oz]

Hi I thought I would upgrade the schema and I know that I don't have 
but.
I couldn't find any documentation on how to do this for *mysql*.
I did it this way and it seems to work. I am using weewx 4.1

stop weewx
Make a backup just in case
mysqldump -uroot -p weewx_new > weewx.sql
Because --reconfigure database makes a database called weewx_new I had to 
allow new permissions for the weewx uer
 mysql -uroot -p 
 GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON `weewx_new`.* TO 
'weewx'@'localhost'
 exit mysql
 add the line below to weewx.conf [[wx_binding]]
 schema = schemas.wview_extended.schema
 wee_database --reconfigure
 mysqldump -uroot -p weewx_new > weewx_new.sql
 the line below is the only way to rename the database
 mysql -uroot -p weewx < weewx_new.sql
 delete the weewx_new database
start weewx and cross your fingers.

I don't know if this is the correct way to do this or if there is 
documentation somewhere else but it works.

On Friday, 22 May 2020 21:20:31 UTC+10, Tom Keffer wrote:
>
> WeeWX Version 4 introduces a new, more flexible, way of specifying 
> schemas. The old way is still supported. If I understand you correctly, 
> you're trying to use the new way on an old copy of WeeWX.
>
> Try upgrading WeeWX, then try again.
>
> -tk
>
> On Thu, May 21, 2020 at 9:26 PM Echo 7 Foxtrot <
> michael...@echo7foxtrot.com > wrote:
>
>> I'm very new...been running my weewx 3.9.2 (rpi4) install for about a 
>> month, using the standard wview.schema.  I've been working on adding some 
>> sensors and wanting to extend the schema, then I saw the wview_extended 
>> schema rolling out with 4.0.  It's got everything I wanted to add in the 
>> near future, and if I'm going to add I thought it'd be best to stick to the 
>> naming conventions chosen for 4.0.  I placed a copy of wview_extended.py 
>> from 4.0 in /weewx/schemas and changed the schema in weewx.conf to 
>> schemas.wview_extended.schema as mentioned in this thread.  This is what I 
>> get:
>>
>> pi@raspberrypi:~ $ sudo wee_database /etc/weewx/weewx.conf --reconfigure
>> Using configuration file /etc/weewx/weewx.conf
>> Using database binding 'wx_binding', which is bound to database 
>> 'archive_sqlite'
>> New database 'weewx.sdb_new' already exists. Delete it first (y/n)? y
>> Copying database 'weewx.sdb' to 'weewx.sdb_new'
>> The new database will use the same unit system as the old ('US').
>> Are you sure you wish to proceed (y/n)? y
>> Traceback (most recent call last):
>>   File "/usr/bin/wee_database", line 794, in 
>> main()
>>   File "/usr/bin/wee_database", line 156, in main
>> reconfigMainDatabase(config_dict, db_binding)
>>   File "/usr/bin/wee_database", line 336, in reconfigMainDatabase
>> new_schema=manager_dict['schema'])
>>   File "/usr/share/weewx/weewx/manager.py", line 817, in reconfig
>> with Manager.open_with_create(new_db_dict, schema=new_schema) as 
>> new_archive:
>>   File "/usr/share/weewx/weewx/manager.py", line 141, in open_with_create
>> dbmanager = cls(connection, table_name=table_name, schema=schema)
>>   File "/usr/share/weewx/weewx/manager.py", line 82, in __init__
>> self._initialize_database(schema)
>>   File "/usr/share/weewx/weewx/manager.py", line 175, in 
>> _initialize_database
>> _sqltypestr = ', '.join(["`%s` %s" % _type for _type in schema])
>> TypeError: not enough arguments for format string
>>
>> The _new .sdb file is created but it is empty (I did it again to capture 
>> for this post, that's why it was already there).  I went to the syslog to 
>> capture anything there for this post as well, but there were no entries 
>> from attempting this.  This first time I tried it I stopped weewx first but 
>> left it running when I ran wee_database the 2nd time...result was the same.
>>
>> Not sure what to do from here...I know just enough about python to have a 
>> general idea of what the problem is but no idea how to digest this and 
>> apply corrective action.  Thanks in advance for any help.
>>
>> -Michael F.
>>
>>
>> On Saturday, May 9, 2020 at 6:57:09 AM UTC-5, Tom Keffer wrote:
>>>
>>> Updating to WeeWX V4 and changing your schema are two different things. 
>>> They have nothing to do with each other. Version 4 offers a new schema, but 
>>> it is used only for new databases.
>>>
>>> If for some reason you wish to change schemas and use the new schema, 
>>> you can do so using either WeeWX V3 or V4. Follow the directions in the 
>>> section *Adding a new type to the database 
>>> * in the 
>>> Customizing Guide, except skip step #1, and in step #2 change this
>>>
>>> [DataBindings]
>>> [[wx_binding]]
>>> database = archive_sqlite
>>> table_name = archive
>>> manager = weewx.wxmanager.DaySummaryManager
>>> schema = user.electricity.electricity_schema
>>>
>>> to this
>>>
>>> [DataBindings]
>>> [[wx_binding]]
>>> database = archive_sqlite
>>> table_name = 

Re: [weewx-user] New Database weewx 4.0

[Tom Keffer]

WeeWX Version 4 introduces a new, more flexible, way of specifying schemas.
The old way is still supported. If I understand you correctly, you're
trying to use the new way on an old copy of WeeWX.

Try upgrading WeeWX, then try again.

-tk

On Thu, May 21, 2020 at 9:26 PM Echo 7 Foxtrot <
michael.flem...@echo7foxtrot.com> wrote:

> I'm very new...been running my weewx 3.9.2 (rpi4) install for about a
> month, using the standard wview.schema.  I've been working on adding some
> sensors and wanting to extend the schema, then I saw the wview_extended
> schema rolling out with 4.0.  It's got everything I wanted to add in the
> near future, and if I'm going to add I thought it'd be best to stick to the
> naming conventions chosen for 4.0.  I placed a copy of wview_extended.py
> from 4.0 in /weewx/schemas and changed the schema in weewx.conf to
> schemas.wview_extended.schema as mentioned in this thread.  This is what I
> get:
>
> pi@raspberrypi:~ $ sudo wee_database /etc/weewx/weewx.conf --reconfigure
> Using configuration file /etc/weewx/weewx.conf
> Using database binding 'wx_binding', which is bound to database
> 'archive_sqlite'
> New database 'weewx.sdb_new' already exists. Delete it first (y/n)? y
> Copying database 'weewx.sdb' to 'weewx.sdb_new'
> The new database will use the same unit system as the old ('US').
> Are you sure you wish to proceed (y/n)? y
> Traceback (most recent call last):
>   File "/usr/bin/wee_database", line 794, in 
> main()
>   File "/usr/bin/wee_database", line 156, in main
> reconfigMainDatabase(config_dict, db_binding)
>   File "/usr/bin/wee_database", line 336, in reconfigMainDatabase
> new_schema=manager_dict['schema'])
>   File "/usr/share/weewx/weewx/manager.py", line 817, in reconfig
> with Manager.open_with_create(new_db_dict, schema=new_schema) as
> new_archive:
>   File "/usr/share/weewx/weewx/manager.py", line 141, in open_with_create
> dbmanager = cls(connection, table_name=table_name, schema=schema)
>   File "/usr/share/weewx/weewx/manager.py", line 82, in __init__
> self._initialize_database(schema)
>   File "/usr/share/weewx/weewx/manager.py", line 175, in
> _initialize_database
> _sqltypestr = ', '.join(["`%s` %s" % _type for _type in schema])
> TypeError: not enough arguments for format string
>
> The _new .sdb file is created but it is empty (I did it again to capture
> for this post, that's why it was already there).  I went to the syslog to
> capture anything there for this post as well, but there were no entries
> from attempting this.  This first time I tried it I stopped weewx first but
> left it running when I ran wee_database the 2nd time...result was the same.
>
> Not sure what to do from here...I know just enough about python to have a
> general idea of what the problem is but no idea how to digest this and
> apply corrective action.  Thanks in advance for any help.
>
> -Michael F.
>
>
> On Saturday, May 9, 2020 at 6:57:09 AM UTC-5, Tom Keffer wrote:
>>
>> Updating to WeeWX V4 and changing your schema are two different things.
>> They have nothing to do with each other. Version 4 offers a new schema, but
>> it is used only for new databases.
>>
>> If for some reason you wish to change schemas and use the new schema, you
>> can do so using either WeeWX V3 or V4. Follow the directions in the section 
>> *Adding
>> a new type to the database
>> * in the
>> Customizing Guide, except skip step #1, and in step #2 change this
>>
>> [DataBindings]
>> [[wx_binding]]
>> database = archive_sqlite
>> table_name = archive
>> manager = weewx.wxmanager.DaySummaryManager
>> schema = user.electricity.electricity_schema
>>
>> to this
>>
>> [DataBindings]
>> [[wx_binding]]
>> database = archive_sqlite
>> table_name = archive
>> manager = weewx.wxmanager.DaySummaryManager
>> schema = schemas.wview_extended.schema
>>
>> -tk
>>
>>
>> On Sat, May 9, 2020 at 4:41 AM Andrea  wrote:
>>
>>> Hi all,
>>> To install new weewx 4.0 with the new DB schema, I need to modify my old
>>> DB schema with my old data?  I've sqllite db.
>>>
>>> Thanks
>>> Andrea
>>>
>>> --
>>> 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...@googlegroups.com.
>>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/weewx-user/1dd6b51f-9e7a-40dd-b054-9eaa25520aea%40googlegroups.com
>>> 
>>> .
>>>
>> --
> 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 

Re: [weewx-user] New Database weewx 4.0

[Echo 7 Foxtrot]

I'm very new...been running my weewx 3.9.2 (rpi4) install for about a 
month, using the standard wview.schema.  I've been working on adding some 
sensors and wanting to extend the schema, then I saw the wview_extended 
schema rolling out with 4.0.  It's got everything I wanted to add in the 
near future, and if I'm going to add I thought it'd be best to stick to the 
naming conventions chosen for 4.0.  I placed a copy of wview_extended.py 
from 4.0 in /weewx/schemas and changed the schema in weewx.conf to 
schemas.wview_extended.schema as mentioned in this thread.  This is what I 
get:

pi@raspberrypi:~ $ sudo wee_database /etc/weewx/weewx.conf --reconfigure
Using configuration file /etc/weewx/weewx.conf
Using database binding 'wx_binding', which is bound to database 
'archive_sqlite'
New database 'weewx.sdb_new' already exists. Delete it first (y/n)? y
Copying database 'weewx.sdb' to 'weewx.sdb_new'
The new database will use the same unit system as the old ('US').
Are you sure you wish to proceed (y/n)? y
Traceback (most recent call last):
  File "/usr/bin/wee_database", line 794, in 
main()
  File "/usr/bin/wee_database", line 156, in main
reconfigMainDatabase(config_dict, db_binding)
  File "/usr/bin/wee_database", line 336, in reconfigMainDatabase
new_schema=manager_dict['schema'])
  File "/usr/share/weewx/weewx/manager.py", line 817, in reconfig
with Manager.open_with_create(new_db_dict, schema=new_schema) as 
new_archive:
  File "/usr/share/weewx/weewx/manager.py", line 141, in open_with_create
dbmanager = cls(connection, table_name=table_name, schema=schema)
  File "/usr/share/weewx/weewx/manager.py", line 82, in __init__
self._initialize_database(schema)
  File "/usr/share/weewx/weewx/manager.py", line 175, in 
_initialize_database
_sqltypestr = ', '.join(["`%s` %s" % _type for _type in schema])
TypeError: not enough arguments for format string

The _new .sdb file is created but it is empty (I did it again to capture 
for this post, that's why it was already there).  I went to the syslog to 
capture anything there for this post as well, but there were no entries 
from attempting this.  This first time I tried it I stopped weewx first but 
left it running when I ran wee_database the 2nd time...result was the same.

Not sure what to do from here...I know just enough about python to have a 
general idea of what the problem is but no idea how to digest this and 
apply corrective action.  Thanks in advance for any help.

-Michael F.


On Saturday, May 9, 2020 at 6:57:09 AM UTC-5, Tom Keffer wrote:
>
> Updating to WeeWX V4 and changing your schema are two different things. 
> They have nothing to do with each other. Version 4 offers a new schema, but 
> it is used only for new databases.
>
> If for some reason you wish to change schemas and use the new schema, you 
> can do so using either WeeWX V3 or V4. Follow the directions in the section 
> *Adding 
> a new type to the database 
> * in the 
> Customizing Guide, except skip step #1, and in step #2 change this
>
> [DataBindings]
> [[wx_binding]]
> database = archive_sqlite
> table_name = archive
> manager = weewx.wxmanager.DaySummaryManager
> schema = user.electricity.electricity_schema
>
> to this
>
> [DataBindings]
> [[wx_binding]]
> database = archive_sqlite
> table_name = archive
> manager = weewx.wxmanager.DaySummaryManager
> schema = schemas.wview_extended.schema
>
> -tk
>
>
> On Sat, May 9, 2020 at 4:41 AM Andrea > 
> wrote:
>
>> Hi all,
>> To install new weewx 4.0 with the new DB schema, I need to modify my old 
>> DB schema with my old data?  I've sqllite db.
>>
>> Thanks
>> Andrea
>>
>> -- 
>> 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...@googlegroups.com .
>> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/weewx-user/1dd6b51f-9e7a-40dd-b054-9eaa25520aea%40googlegroups.com
>>  
>> 
>> .
>>
>

-- 
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/a46a8292-4354-4a95-a2f7-8882fab7589a%40googlegroups.com.

Re: [weewx-user] New Database weewx 4.0

[Tom Keffer]

Unfortunately, there's no list. You'll have to do a mental diff of the two
files schemas/wview.py and schemas/wview_extended.py.

On Sun, May 10, 2020 at 5:57 AM Tom Mitchell  wrote:

> Apologies.. I think I looked in the docs and couldn't find a list of new
> types to potentially take advantage of. Any pointers appreciated.
>
>
> On Saturday, May 9, 2020 at 8:28:50 AM UTC-4, Tom Keffer wrote:
>>
>> Only if you can take advantage of some of the new types.
>>
>>
>>>
>>> --
> 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/1f141e8a-9ddb-4524-bab9-4afb4fb5fb08%40googlegroups.com
> 
> .
>

-- 
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/CAPq0zEC_AUHLFsc7iKwuEDqbLdvaygmwXtEV7bA9k8q%3Dmk1%3D3w%40mail.gmail.com.

Re: [weewx-user] New Database weewx 4.0

[Tom Mitchell]

Apologies.. I think I looked in the docs and couldn't find a list of new 
types to potentially take advantage of. Any pointers appreciated.


On Saturday, May 9, 2020 at 8:28:50 AM UTC-4, Tom Keffer wrote:
>
> Only if you can take advantage of some of the new types.
>
>
>>
>>

-- 
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/1f141e8a-9ddb-4524-bab9-4afb4fb5fb08%40googlegroups.com.

Re: [weewx-user] New Database weewx 4.0

[Andrea]

Thanks Tom

Andrea

Il giorno sabato 9 maggio 2020 13:58:45 UTC+2, Tom Mitchell ha scritto:
>
> Is there any reason to convert databases created and populated under 3.x 
> to the 4.0 schema?
>
> On Saturday, May 9, 2020 at 7:57:09 AM UTC-4, Tom Keffer wrote:
>>
>> Updating to WeeWX V4 and changing your schema are two different things. 
>> They have nothing to do with each other. Version 4 offers a new schema, but 
>> it is used only for new databases.
>>
>>>
>>>

-- 
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/990bed4a-8c0a-45fa-82b4-952f5f9dd651%40googlegroups.com.

Re: [weewx-user] New Database weewx 4.0

[Tom Keffer]

Only if you can take advantage of some of the new types.

On Sat, May 9, 2020 at 4:58 AM Tom Mitchell  wrote:

> Is there any reason to convert databases created and populated under 3.x
> to the 4.0 schema?
>
> On Saturday, May 9, 2020 at 7:57:09 AM UTC-4, Tom Keffer wrote:
>>
>> Updating to WeeWX V4 and changing your schema are two different things.
>> They have nothing to do with each other. Version 4 offers a new schema, but
>> it is used only for new databases.
>>
>>>
>>> --
> 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/269c32de-00d6-463d-bb3f-f0115dec685c%40googlegroups.com
> 
> .
>

-- 
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/CAPq0zECKhVmr0hpyCyigiDDs8%3Dz5O%2B6wFwNndxCPJ6UQRa_e8Q%40mail.gmail.com.

Re: [weewx-user] New Database weewx 4.0

[Tom Mitchell]

Is there any reason to convert databases created and populated under 3.x to 
the 4.0 schema?

On Saturday, May 9, 2020 at 7:57:09 AM UTC-4, Tom Keffer wrote:
>
> Updating to WeeWX V4 and changing your schema are two different things. 
> They have nothing to do with each other. Version 4 offers a new schema, but 
> it is used only for new databases.
>
>>
>>

-- 
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/269c32de-00d6-463d-bb3f-f0115dec685c%40googlegroups.com.

Re: [weewx-user] New Database weewx 4.0

[Tom Keffer]

Updating to WeeWX V4 and changing your schema are two different things.
They have nothing to do with each other. Version 4 offers a new schema, but
it is used only for new databases.

If for some reason you wish to change schemas and use the new schema, you
can do so using either WeeWX V3 or V4. Follow the directions in the
section *Adding
a new type to the database
* in the
Customizing Guide, except skip step #1, and in step #2 change this

[DataBindings]
[[wx_binding]]
database = archive_sqlite
table_name = archive
manager = weewx.wxmanager.DaySummaryManager
schema = user.electricity.electricity_schema

to this

[DataBindings]
[[wx_binding]]
database = archive_sqlite
table_name = archive
manager = weewx.wxmanager.DaySummaryManager
schema = schemas.wview_extended.schema

-tk


On Sat, May 9, 2020 at 4:41 AM Andrea  wrote:

> Hi all,
> To install new weewx 4.0 with the new DB schema, I need to modify my old
> DB schema with my old data?  I've sqllite db.
>
> Thanks
> Andrea
>
> --
> 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/1dd6b51f-9e7a-40dd-b054-9eaa25520aea%40googlegroups.com
> 
> .
>

-- 
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/CAPq0zEACk4Q_J3F8zPEYQmDCRqt7OjXyfjb77g092LcUO3taZw%40mail.gmail.com.

[weewx-user] New Database weewx 4.0

[Andrea]

Hi all,
To install new weewx 4.0 with the new DB schema, I need to modify my old DB 
schema with my old data?  I've sqllite db.

Thanks
Andrea

-- 
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/1dd6b51f-9e7a-40dd-b054-9eaa25520aea%40googlegroups.com.