Dump and restore them is one way - see (link) <https://github.com/vinceskahan/weewx/blob/main/weewx-odds-and-ends/db-dump-restore.txt> for details, and be sure to run ‘weectl database rebuild-daily’ to rebuild the summary tables.
On Tuesday, November 11, 2025 at 8:25:05 AM UTC-8 Günther Wrana wrote: > Hello, > > i have now also a problem with my two weewx.sdb datebase how can i merge > this two to one database? > > Thank you for the help! > > Günther Wrana > > > > Meteo Oberwallis schrieb am Freitag, 5. August 2022 um 14:39:24 UTC+2: > >> Hallo. >> >> Ich möchte die Sonnenscheinzeit meiner Wetterstation vom Jahr 2006 ab >> nachführen in weewx. In der weewx.sdb befindet sich die Spalte >> "sunshine_time". Nun habe ich probiert, die Daten hoch zu laden über >> folgenden Code: >> [[FieldMap]] >> dateTime = Zeit, unix_epoch >> usUnits = >> interval = >> barometer = Luftdruck, hPa >> pressure = >> altimeter = >> inTemp = >> outTemp = Temp. A., degree_C >> inHumidity = >> outHumidity = Feuchte A., percent >> windSpeed = Wind, km_per_hour >> windDir = Richtung, degree_compass >> windGust = Windboe, km_per_hour >> windGustDir = >> rainRate = >> rain = Regen, mm >> dewpoint = >> windchill = >> heatindex = >> ET = >> radiation = Solar, watt_per_meter_squared >> UV = UV, uv_index >> sunshine_time = Sonnenschein, hour >> >> Leider ergibt dies immer einen Fehler: >> /home/technik# sudo wee_import --import-config=/var/tmp/csv.conf >> Using WeeWX configuration file /etc/weewx/weewx.conf >> Starting wee_import... >> A CSV import from source file >> '/home/technik/Schreibtisch/Grächen/EXP_2006.CSV' has been requested. >> >> Using database binding 'wx_binding', which is bound to database >> 'weewx.sdb' >> Destination table 'archive' unit system is '0x01' (US). >> Missing derived observations will be calculated. >> All WeeWX UV fields will be set to None. >> Starting import ... >> Warning: Import field 'UV' is mapped to WeeWX field 'UV' but the >> import field 'UV' could not be found in one or more records. >> WeeWX field 'UV' will be set to 'None' in these records. >> >> Traceback (most recent call last): >> File "/usr/share/weewx/wee_import", line 899, in <module> >> main() >> File "/usr/share/weewx/wee_import", line 829, in main >> source_obj.run() >> File "/usr/share/weewx/weeimport/weeimport.py", line 410, in run >> _mapped_data = self.mapRawData(_raw_data, self.archive_unit_sys) >> File "/usr/share/weewx/weeimport/weeimport.py", line 941, in mapRawData >> weewx.units.obs_group_dict[_field]) >> File "/usr/share/weewx/weeutil/weeutil.py", line 1501, in __getitem__ >> return self.__missing__(key) >> File "/usr/share/weewx/weeutil/weeutil.py", line 1493, in __missing__ >> raise KeyError(key) >> KeyError: u'sunshine_time' >> >> Woran könnte das liegen? >> >> Danke für eure Hilfe >> Meteo Oberwallis schrieb am Montag, 18. April 2022 um 11:28:04 UTC+2: >> >>> Hallo zusammen. >>> Ich probiere nun schon seit geraumer Zeit, die weewx.sdb der Version >>> 3.9.0 mit der neuen weewx.sdb der aktuellen Version 4.7.0 zusammen zu >>> legen. Dies klappte bis anhin leider nicht. Nun vermute ich aber, das dies >>> daran liegt, das ab der Version 4.7 ein anderes Shema benutzt wird? >>> Interessanterweise konnte ich die alte weewx.sdb mit wee_database >>> weewx.conf --reconfigure in das richtige format bringen. Nun aber fehlen >>> mit die "sunshine_hours". Die neuste Version von weewx hat ja ebenfalls ein >>> neues "sunshine_time" format. Nun wollte die mittels "rename" einfach die >>> Tabllenespalte anpassen. Dies blieb aber erfolglos. Kann ich die >>> "sunshine_hours" über einen anderen weg ind die neue weewx.sdb in dessen >>> "sunshine_time" spalte kopieren? >>> Ich weiss wirklich nicht mehr weiter und würde mich über Hilfen freuen. >>> Vielen Dank >>> >>> Der Fehler bei der Datenbank zusammenführung: >>> Error: near line 333827: table archive has 114 columns but 53 values >>> were supplied >>> Error: near line 333828: table archive has 114 columns but 53 values >>> were supplied >>> Error: near line 333829: table archive has 114 columns but 53 values >>> were supplied >>> Error: near line 333830: table archive has 114 columns but 53 values >>> were supplied >>> Error: near line 333831: table archive has 114 columns but 53 values >>> were supplied >>> Error: near line 333832: table archive has 114 columns but 53 values >>> were supplied >>> Error: near line 333833: table archive has 114 columns but 53 values >>> were supplied >>> Error: near line 333834: table archive has 114 columns but 53 values >>> were supplied >>> Error: near line 333835: table archive has 114 columns but 53 values >>> were supplied >>> Error: near line 333836: table archive has 114 columns but 53 values >>> were supplied >>> Error: near line 333837: table archive has 114 columns but 53 values >>> were supplied >>> Error: near line 333838: table archive has 114 columns but 53 values >>> were supplied >>> Error: near line 333839: table archive has 114 columns but 53 values >>> were supplied >>> Error: near line 333840: table archive has 114 columns but 53 values >>> were supplied >>> Error: near line 333841: table archive has 114 columns but 53 values >>> were supplied >>> Error: near line 333842: table archive has 114 columns but 53 values >>> were supplied >>> Error: near line 333843: table archive has 114 columns but 53 values >>> were supplied >>> Error: near line 333844: table archive has 114 columns but 53 values >>> were supplied >>> Error: near line 333845: table archive has 114 columns but 53 values >>> were supplied >>> Error: near line 333846: table archive has 114 columns but 53 values >>> were supplied >>> Error: near line 333847: table archive has 114 columns but 53 values >>> were supplied >>> Error: near line 333848: table archive has 114 columns but 53 values >>> were supplied >>> Error: near line 333849: table archive has 114 columns but 53 values >>> were supplied >>> Error: near line 333850: table archive has 114 columns but 53 values >>> were supplied >>> Error: near line 333851: table archive has 114 columns but 53 values >>> were supplied >>> Error: near line 333852: table archive has 114 columns but 53 values >>> were supplied >>> >>> >>> Hello, everyone. >>> For some time now I've been trying to merge the weewx.sdb of version >>> 3.9.0 with the new weewx.sdb of the current version 4.7.0. Unfortunately, >>> this has not worked so far. But now I assume that this is due to the fact >>> that a different shema is used from version 4.7 onwards? Interestingly, I >>> was able to get the old weewx.sdb into the right format with wee_database >>> weewx.conf --reconfigure. But now I'm missing the "sunshine_hours". The >>> latest version of weewx also has a new "sunshine_time" format. Now she just >>> wanted to adjust the table column using "rename". But this was >>> unsuccessful. Can I use another way to copy the "sunshine_hours" into the >>> new weewx.sdb in its "sunshine_time" column? >>> I really don't know what to do and would appreciate any help. Thanks >>> very much >>> >>> Meteo Oberwallis schrieb am Donnerstag, 31. März 2022 um 11:35:55 UTC+2: >>> >>>> Hello, everyone. >>>> >>>> The error really seems to be with the database, i.e. SQLite, since the >>>> "user.sunduration.schema_with_sunshine_time" will have a different >>>> structure. But what can I do now so that I can use my old database from >>>> the >>>> previous weewx version again with the latest version and thus overwrite >>>> the >>>> sunshine hours (old name in the old weewx.sdb) in the new one? >>>> >>>> Many thanks for your help >>>> >>>> Meteo Oberwallis schrieb am Montag, 28. März 2022 um 19:39:22 UTC+2: >>>> >>>>> Hey Tom. >>>>> >>>>> >>>>> >>>>> Thx for your Help. >>>>> >>>>> In the new weewx version, "schema = schemas.wview_extended.schema" is >>>>> used with the table. In the previous version of weewx, however, this was >>>>> "schema = user.radiationhours.schema_with_sunshine_hours". What exactly >>>>> do >>>>> I have to do if I transfer my old weewx.sdb to the program? Do I then >>>>> have >>>>> to adapt these with sudo wee_database weewx.conf --reconfigure to the >>>>> ""schema = schemas.wview_extended.schema"? I think that's where my >>>>> problem >>>>> lies. >>>>> >>>>> >>>>> >>>>> Currently I did the following: Old weewx.sdb in the /var/lib/weewx/ >>>>> folder. Then adjust the column names with "wee_database >>>>> --rename-column=sunshine_hours --to-name=sunshine_time" and finally >>>>> adjust >>>>> the new Shmea from weewx with sudo wee_database weewx.conf --reconfigure. >>>>> After I did that, the "sunshine_time" column was gone. Only after "sudo >>>>> wee_database --add-column=sunshine_time" is it back, but unfortunately >>>>> without all the data from the last few years. >>>>> >>>>> >>>>> >>>>> Where is my mistake? >>>>> >>>>> >>>>> >>>>> *Von:* [email protected] <[email protected]> *Im >>>>> Auftrag von *Tom Keffer >>>>> *Gesendet:* Montag, 28. März 2022 13:51 >>>>> *An:* weewx-user <[email protected]> >>>>> *Betreff:* Re: [weewx-user] Re: Datenbank zusammen legen. >>>>> >>>>> >>>>> >>>>> If I understand correctly, you're trying to rename a database type >>>>> from sunshine_hours to sunshine_time. >>>>> >>>>> >>>>> >>>>> If so, use the utility wee_database with the --rename-column >>>>> <http://www.weewx.com/docs/utilities.htm#Action_--rename-column> >>>>> option: >>>>> >>>>> >>>>> >>>>> *wee_database --rename-column=sunshine_hours --to-name=sunshine_time* >>>>> >>>>> >>>>> >>>>> Make a backup first. >>>>> >>>>> >>>>> >>>>> On Mon, Mar 28, 2022 at 12:14 AM Meteo Oberwallis <[email protected]> >>>>> wrote: >>>>> >>>>> Good Morning >>>>> >>>>> >>>>> >>>>> I have a question regarding the SQLite database. I updated weewx and >>>>> now use sunshine_time instead of sunshine_hours. Now of course the >>>>> problem >>>>> is that the old sunshine times are in the sunshine_hours column and not >>>>> in >>>>> the sunshine_time. How can I fix the fact that the old sunshine_hours >>>>> data >>>>> is now being sent to the sunshine_time splate? >>>>> >>>>> Thanks and Greetings >>>>> >>>>> [email protected] schrieb am Sonntag, 19. April 2020 um 19:30:30 >>>>> UTC+2: >>>>> >>>>> Hallo >>>>> >>>>> >>>>> >>>>> wenn du die Standard Installation hast ist das >>>>> /home/weewx/public_html/NOAA oder /var/www/html/weewx/NOAA so wie es >>>>> Gary geschrieben hat. >>>>> >>>>> >>>>> >>>>> Grüße >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> Hello >>>>> >>>>> >>>>> >>>>> if you have the standard installation this is >>>>> /home/weewx/public_html/NOAA or /var/www/html/weewx/NOAA as Gary wrote it. >>>>> >>>>> >>>>> >>>>> greetings >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> Am Sonntag, 19. April 2020 13:58:05 UTC+2 schrieb Meteo Oberwallis: >>>>> >>>>> Hallo Günther >>>>> >>>>> >>>>> >>>>> Nun. Das finde ich so nirgends in meinem weewx Ordner. Ist das der >>>>> Ordner, bevor es via FTP hochgeladen wird? >>>>> >>>>> >>>>> >>>>> Gruss >>>>> >>>>> >>>>> >>>>> *Von:* [email protected] <[email protected]> *Im >>>>> Auftrag von *Günther Wrana >>>>> *Gesendet:* Sonntag, 19. April 2020 08:32 >>>>> *An:* weewx-user <[email protected]> >>>>> *Betreff:* Re: [weewx-user] Re: Datenbank zusammen legen. >>>>> >>>>> >>>>> >>>>> Hallo >>>>> >>>>> >>>>> >>>>> Ich habe die Dateien im /var/weewx/reports/NOAA gelöscht aber ich habe >>>>> diesen Pfad bei mir vorher so geändert damit diese Dateien nicht auf die >>>>> SD-Karte sondern in den RAM Speicher geschrieben werden. >>>>> >>>>> >>>>> >>>>> Grüße Günther >>>>> >>>>> Hello >>>>> >>>>> >>>>> >>>>> I deleted the files in /var/weewx/reports/NOAA but I changed this path >>>>> for me beforehand so that these files are not written to the SD card but >>>>> to >>>>> the RAM memory. >>>>> >>>>> >>>>> >>>>> Regards Günther >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> Am Samstag, 18. April 2020 17:45:24 UTC+2 schrieb Meteo Oberwallis: >>>>> >>>>> Hallo Günther >>>>> >>>>> >>>>> >>>>> In welchem Ordner hast du das gelöscht? >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> On Sat, Apr 18, 2020 at 5:34 PM +0200, "Günther Wrana" < >>>>> [email protected]> wrote: >>>>> >>>>> Hello >>>>> >>>>> I deleted the file NOAA-2019-05.txt, NOAA-2019.txt and it worked >>>>> perfectly. For me is now the 01.05.2015 that I imported. The fact that >>>>> there is nothing inside has happened to me even though I have only >>>>> deleted >>>>> the NOAA.txt. Maybe you have to restart or reload weewx. >>>>> >>>>> >>>>> >>>>> Günther >>>>> >>>>> >>>>> Am Samstag, 18. April 2020 14:56:21 UTC+2 schrieb Meteo Oberwallis: >>>>> >>>>> Hello. >>>>> >>>>> I have now deleted the data in the folder "/var/www/html/weewx/NOAA/". >>>>> These came again after the next interval. Unfortunately without data. Do >>>>> I have to delete it anywhere else? >>>>> >>>>> Thank you for your top help >>>>> >>>>> >>>>> >>>>> Am Freitag, 17. April 2020 23:42:39 UTC+2 schrieb gjr80: >>>>> >>>>> Hallo Günther, >>>>> >>>>> Good to hear you have imported your data and WeeWX is running without >>>>> error. You need WeeWX to recreate all of your NOAA format reports, to do >>>>> this just delete the reports on your WeeWX machine and they will be >>>>> recreated (including your earlier ones) on the next report cycle. >>>>> >>>>> Gary >>>>> >>>>> -- >>>>> 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/8fc609f0-224a-4205-98d4-410a7acc759f%40googlegroups.com >>>>> >>>>> <https://groups.google.com/d/msgid/weewx-user/8fc609f0-224a-4205-98d4-410a7acc759f%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/f02b56bc-8550-45f7-95ae-3e58054284d5%40googlegroups.com >>>>> >>>>> <https://groups.google.com/d/msgid/weewx-user/f02b56bc-8550-45f7-95ae-3e58054284d5%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/f7df793b-6e6b-43f8-95e8-799af2218b3en%40googlegroups.com >>>>> >>>>> <https://groups.google.com/d/msgid/weewx-user/f7df793b-6e6b-43f8-95e8-799af2218b3en%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>> . >>>>> >>>>> -- >>>>> You received this message because you are subscribed to a topic in the >>>>> Google Groups "weewx-user" group. >>>>> To unsubscribe from this topic, visit >>>>> https://groups.google.com/d/topic/weewx-user/86KPd-dyvD4/unsubscribe. >>>>> To unsubscribe from this group and all its topics, send an email to >>>>> [email protected]. >>>>> To view this discussion on the web visit >>>>> https://groups.google.com/d/msgid/weewx-user/CAPq0zEBx1WzUgoiV%2Bj07vMVqW7seYe6jM-3WCmks2ZmREeVmCQ%40mail.gmail.com >>>>> >>>>> <https://groups.google.com/d/msgid/weewx-user/CAPq0zEBx1WzUgoiV%2Bj07vMVqW7seYe6jM-3WCmks2ZmREeVmCQ%40mail.gmail.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 visit https://groups.google.com/d/msgid/weewx-user/d9a3996f-c07a-475b-b171-0aa7fda4c9fan%40googlegroups.com.
