Hallo Gary,
i use the original weewx-wd
<https://bitbucket.org/ozgreg/weewx-wd/src/110688ada0c6?at=v1.2.0_development>
/ bin
<https://bitbucket.org/ozgreg/weewx-wd/src/110688ada0c6/bin/?at=v1.2.0_development>
/ user
<https://bitbucket.org/ozgreg/weewx-wd/src/110688ada0c6/bin/user/?at=v1.2.0_development>
/ weewxwd_config
Version: 1.2.0b2
#!/usr/bin/env python## This program is free software; you can redistribute it
and/or modify it under# the terms of the GNU General Public License as
published by the Free Software# Foundation; either version 2 of the License, or
(at your option) any later# version.## This program is distributed in the hope
that it will be useful, but WITHOUT # ANY WARRANTY; without even the implied
warranty of MERCHANTABILITY or FITNESS# FOR A PARTICULAR PURPOSE. See the GNU
General Public License for more# details.## Version: 1.2.0b2
Date: 5 September 2015## Revision History# ?? September 2015
v1.2.0 - Initial implementation, based upon portions of#
weewxwd3.py#"""Manage the databases used by Weewx-WD"""from
__future__ import with_statement
############################################
to clear extraTemp1 and extraTemp2 from weewxAlt (current weewx database)
#######################################
my weewx.conf
[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_mysql
# 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.schemas.schema
[[wd_binding]]
# The database must match one of the sections in [Databases]
database = wd_mysql
table_name = archive
manager = weewx.wxmanager.WXDaySummaryManager
schema = schemas.wdSchema.weewxwd_schema
##############################################
and for weewxwd database weewxAltWD
root@acer:/home/weewx/bin/user# weewxwd_config --clear-v2-data
--wx-binding=wx_binding
-bash: weewxwd_config: Kommando nicht gefunden.
root@acer:/home/weewx/bin/user# ./weewxwd_config.py --clear-v2-data
--wx-binding=wx_binding
Using configuration file /home/weewx/weewx.conf
Using database binding 'wx_binding', which is bound to database
'archive_mysql'
Using database binding 'wd_binding', which is bound to database 'wd_mysql'
'extraTemp1' and 'extraTemp2' data in database 'weewxAlt' from 2013-10-31
22:19:00 CET (1383254340) to 2017-03-11 12:50:00 CET (1489233000) (approx
1227 days) is about to be cleared.
Any data in these fields will be irretrievably lost.
Are you sure you wish to proceed (y/n)? y
Done. 'extraTemp1' and 'extraTemp2' cleared in 351357 records (approx 1227
days).
root@acer:/home/weewx/bin/user#
copy by phpmyadmin
Server: localhost
<http://amd350/phpmyadmin/index.php?token=1002f5d713b9cf2cf097d85813db033e>
»Datenbank: weewxAlt
<http://amd350/phpmyadmin/db_structure.php?db=weewxAlt&token=1002f5d713b9cf2cf097d85813db033e>
»Tabelle: archive
<http://amd350/phpmyadmin/sql.php?db=weewxAlt&table=archive&token=1002f5d713b9cf2cf097d85813db033e>
SELECT
<http://amd350/phpmyadmin/url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.5%2Fen%2Fselect.html>
`dateTime`, `usUnits`, `interval`, `extraTemp1`, `extraTemp2` FROM `archive`
WHERE `extraTemp1` >0;
[image: Vollständige Texte]
<http://amd350/phpmyadmin/sql.php?db=weewxAlt&table=archive&sql_query=SELECT+%60dateTime%60%2C+%60usUnits%60%2C+%60interval%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+WHERE+%60extraTemp1%60+%3E0&goto=tbl_sql.php&full_text_button=1&pftext=F&token=1002f5d713b9cf2cf097d85813db033e>
dateTime
<http://amd350/phpmyadmin/sql.php?db=weewxAlt&table=archive&sql_query=SELECT+%60dateTime%60%2C+%60usUnits%60%2C+%60interval%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+WHERE+%60extraTemp1%60+%3E0%0AORDER+BY+%60archive%60.%60dateTime%60+ASC&session_max_rows=25&token=1002f5d713b9cf2cf097d85813db033e>
usUnits
<http://amd350/phpmyadmin/sql.php?db=weewxAlt&table=archive&sql_query=SELECT+%60dateTime%60%2C+%60usUnits%60%2C+%60interval%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+WHERE+%60extraTemp1%60+%3E0%0AORDER+BY+%60archive%60.%60usUnits%60+ASC&session_max_rows=25&token=1002f5d713b9cf2cf097d85813db033e>
interval
<http://amd350/phpmyadmin/sql.php?db=weewxAlt&table=archive&sql_query=SELECT+%60dateTime%60%2C+%60usUnits%60%2C+%60interval%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+WHERE+%60extraTemp1%60+%3E0%0AORDER+BY+%60archive%60.%60interval%60+ASC&session_max_rows=25&token=1002f5d713b9cf2cf097d85813db033e>
extraTemp1
<http://amd350/phpmyadmin/sql.php?db=weewxAlt&table=archive&sql_query=SELECT+%60dateTime%60%2C+%60usUnits%60%2C+%60interval%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+WHERE+%60extraTemp1%60+%3E0%0AORDER+BY+%60archive%60.%60extraTemp1%60+ASC&session_max_rows=25&token=1002f5d713b9cf2cf097d85813db033e>
extraTemp2
<http://amd350/phpmyadmin/sql.php?db=weewxAlt&table=archive&sql_query=SELECT+%60dateTime%60%2C+%60usUnits%60%2C+%60interval%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+WHERE+%60extraTemp1%60+%3E0%0AORDER+BY+%60archive%60.%60extraTemp2%60+ASC&session_max_rows=25&token=1002f5d713b9cf2cf097d85813db033e>
[image: Bearbeiten] Bearbeiten
<http://amd350/phpmyadmin/tbl_change.php?db=weewxAlt&table=archive&where_clause=%60archive%60.%60dateTime%60+%3D+1406844062&clause_is_unique=1&sql_query=SELECT+%60dateTime%60%2C+%60usUnits%60%2C+%60interval%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+WHERE+%60extraTemp1%60+%3E0&goto=sql.php&default_action=update&token=1002f5d713b9cf2cf097d85813db033e>
[image:
Kopieren] Kopieren
<http://amd350/phpmyadmin/tbl_change.php?db=weewxAlt&table=archive&where_clause=%60archive%60.%60dateTime%60+%3D+1406844062&clause_is_unique=1&sql_query=SELECT+%60dateTime%60%2C+%60usUnits%60%2C+%60interval%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+WHERE+%60extraTemp1%60+%3E0&goto=sql.php&default_action=insert&token=1002f5d713b9cf2cf097d85813db033e>
[image:
Löschen] Löschen
<http://amd350/phpmyadmin/sql.php?db=weewxAlt&table=archive&sql_query=DELETE+FROM+%60weewxAlt%60.%60archive%60+WHERE+%60archive%60.%60dateTime%60+%3D+1406844062&message_to_show=Der+Datensatz+wurde+gel%C3%B6scht.&goto=sql.php%3Fdb%3DweewxAlt%26table%3Darchive%26sql_query%3DSELECT%2B%2560dateTime%2560%252C%2B%2560usUnits%2560%252C%2B%2560interval%2560%252C%2B%2560extraTemp1%2560%252C%2B%2560extraTemp2%2560%2BFROM%2B%2560archive%2560%2BWHERE%2B%2560extraTemp1%2560%2B%253E0%26message_to_show%3DDer%2BDatensatz%2Bwurde%2Bgel%25C3%25B6scht.%26goto%3Dtbl_sql.php%26token%3D1002f5d713b9cf2cf097d85813db033e&token=1002f5d713b9cf2cf097d85813db033e>
1406844062 16 5 19.375 16.4375
[image: Bearbeiten] Bearbeiten
<http://amd350/phpmyadmin/tbl_change.php?db=weewxAlt&table=archive&where_clause=%60archive%60.%60dateTime%60+%3D+1406844361&clause_is_unique=1&sql_query=SELECT+%60dateTime%60%2C+%60usUnits%60%2C+%60interval%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+WHERE+%60extraTemp1%60+%3E0&goto=sql.php&default_action=update&token=1002f5d713b9cf2cf097d85813db033e>
[image:
Kopieren] Kopieren
<http://amd350/phpmyadmin/tbl_change.php?db=weewxAlt&table=archive&where_clause=%60archive%60.%60dateTime%60+%3D+1406844361&clause_is_unique=1&sql_query=SELECT+%60dateTime%60%2C+%60usUnits%60%2C+%60interval%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+WHERE+%60extraTemp1%60+%3E0&goto=sql.php&default_action=insert&token=1002f5d713b9cf2cf097d85813db033e>
[image:
Löschen] Löschen
<http://amd350/phpmyadmin/sql.php?db=weewxAlt&table=archive&sql_query=DELETE+FROM+%60weewxAlt%60.%60archive%60+WHERE+%60archive%60.%60dateTime%60+%3D+1406844361&message_to_show=Der+Datensatz+wurde+gel%C3%B6scht.&goto=sql.php%3Fdb%3DweewxAlt%26table%3Darchive%26sql_query%3DSELECT%2B%2560dateTime%2560%252C%2B%2560usUnits%2560%252C%2B%2560interval%2560%252C%2B%2560extraTemp1%2560%252C%2B%2560extraTemp2%2560%2BFROM%2B%2560archive%2560%2BWHERE%2B%2560extraTemp1%2560%2B%253E0%26message_to_show%3DDer%2BDatensatz%2Bwurde%2Bgel%25C3%25B6scht.%26goto%3Dtbl_sql.php%26token%3D1002f5d713b9cf2cf097d85813db033e&token=1002f5d713b9cf2cf097d85813db033e>
1406844361 16 5 19.375 16.375
[image: Bearbeiten] Bearbeiten
<http://amd350/phpmyadmin/tbl_change.php?db=weewxAlt&table=archive&where_clause=%60archive%60.%60dateTime%60+%3D+1406844662&clause_is_unique=1&sql_query=SELECT+%60dateTime%60%2C+%60usUnits%60%2C+%60interval%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+WHERE+%60extraTemp1%60+%3E0&goto=sql.php&default_action=update&token=1002f5d713b9cf2cf097d85813db033e>
[image:
Kopieren] Kopieren
<http://amd350/phpmyadmin/tbl_change.php?db=weewxAlt&table=archive&where_clause=%60archive%60.%60dateTime%60+%3D+1406844662&clause_is_unique=1&sql_query=SELECT+%60dateTime%60%2C+%60usUnits%60%2C+%60interval%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+WHERE+%60extraTemp1%60+%3E0&goto=sql.php&default_action=insert&token=1002f5d713b9cf2cf097d85813db033e>
[image:
Löschen] Löschen
<http://amd350/phpmyadmin/sql.php?db=weewxAlt&table=archive&sql_query=DELETE+FROM+%60weewxAlt%60.%60archive%60+WHERE+%60archive%60.%60dateTime%60+%3D+1406844662&message_to_show=Der+Datensatz+wurde+gel%C3%B6scht.&goto=sql.php%3Fdb%3DweewxAlt%26table%3Darchive%26sql_query%3DSELECT%2B%2560dateTime%2560%252C%2B%2560usUnits%2560%252C%2B%2560interval%2560%252C%2B%2560extraTemp1%2560%252C%2B%2560extraTemp2%2560%2BFROM%2B%2560archive%2560%2BWHERE%2B%2560extraTemp1%2560%2B%253E0%26message_to_show%3DDer%2BDatensatz%2Bwurde%2Bgel%25C3%25B6scht.%26goto%3Dtbl_sql.php%26token%3D1002f5d713b9cf2cf097d85813db033e&token=1002f5d713b9cf2cf097d85813db033e>
1406844662 16 5 19.375 16.3125
[image: Bearbeiten] Bearbeiten
<http://amd350/phpmyadmin/tbl_change.php?db=weewxAlt&table=archive&where_clause=%60archive%60.%60dateTime%60+%3D+1406844961&clause_is_unique=1&sql_query=SELECT+%60dateTime%60%2C+%60usUnits%60%2C+%60interval%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+WHERE+%60extraTemp1%60+%3E0&goto=sql.php&default_action=update&token=1002f5d713b9cf2cf097d85813db033e>
[image:
Kopieren] Kopieren
<http://amd350/phpmyadmin/tbl_change.php?db=weewxAlt&table=archive&where_clause=%60archive%60.%60dateTime%60+%3D+1406844961&clause_is_unique=1&sql_query=SELECT+%60dateTime%60%2C+%60usUnits%60%2C+%60interval%60%2C+%60extraTemp1%60%2C+%60extraTemp2%60+FROM+%60archive%60+WHERE+%60extraTemp1%60+%3E0&goto=sql.php&default_action=insert&token=1002f5d713b9cf2cf097d85813db033e>
[image:
Löschen] Löschen
<http://amd350/phpmyadmin/sql.php?db=weewxAlt&table=archive&sql_query=DELETE+FROM+%60weewxAlt%60.%60archive%60+WHERE+%60archive%60.%60dateTime%60+%3D+1406844961&message_to_show=Der+Datensatz+wurde+gel%C3%B6scht.&goto=sql.php%3Fdb%3DweewxAlt%26table%3Darchive%26sql_query%3DSELECT%2B%2560dateTime%2560%252C%2B%2560usUnits%2560%252C%2B%2560interval%2560%252C%2B%2560extraTemp1%2560%252C%2B%2560extraTemp2%2560%2BFROM%2B%2560archive%2560%2BWHERE%2B%2560extraTemp1%2560%2B%253E0%26message_to_show%3DDer%2BDatensatz%2Bwurde%2Bgel%25C3%25B6scht.%26goto%3Dtbl_sql.php%26token%3D1002f5d713b9cf2cf097d85813db033e&token=1002f5d713b9cf2cf097d85813db033e>
1406844961 16 5 19.375 16.25
|
10596
Anzahl der Datensätze:
by phpmyadmin: Zeige Datensätze 264875 - 264892 (264893 insgesamt, Die
Abfrage dauerte 2.2757 Sekunden.)
<<<Any data in these fields will be irretrievably lost????>>> Nothing was
deleted
Nothing was deleted
Hartmut
