For the record: >From Meteobridge -> Database -> Administration -> Import/Export
>From there I exported the records needed into a text file. Now the last question, what I see for colume headings in the Web UI: TEMPERATURE (F), RAIN (in), WIND SPEED (mph) HEAT COOL AVG MEAN DEG DEG WIND DOM DAY TEMP HIGH TIME LOW TIME DAYS DAYS RAIN SPEED HIGH TIME DIR --------------------------------------------------------------------------------------- The exported data: Temperature in F, Rain in INCH, Wind Spped in MPH, Pressure in INHG AVG AVG DOM DAY TEMP HIGH TIME LOW TIME RAIN WIND HIGH TIME DIR BAROM HUM --------------------------------------------------------------------------------------- I understand that the Heat & Cool Deg days are a calculation from the Avg Temp and 65, would these values get recalculated when I bring up the reports on the WebUI? Or would this be an application of weectl database calc-missing for the date range I need? On Friday, January 23, 2026 at 10:43:27 PM UTC-5 Jim Wilkerson wrote: > Is there a way I can download the data in my Meteobridge NanoSD into the > weewx.sdb which would hopefully restore the missing records? I think I did > this once before from my previous Davis data logger... > > > On Thursday, January 22, 2026 at 11:01:07 PM UTC-5 Jim Wilkerson wrote: > >> Oh.... >> >> The database was root:weewx >> >> chown weewx:weewx fixed that part. >> >> On Thursday, January 22, 2026 at 10:55:58 PM UTC-5 Jim Wilkerson wrote: >> >>> Well, now I have managed to make my database read-only: >>> >>> Jan 22 22:54:02 linux-3wjh weewxd[7035]: ERROR weewx.manager: Unable to >>> add record 2026-01-22 13:00:00 EST (1769104800)> >>> >>> Can I use the weectl database command to fix this? >>> On Wednesday, January 21, 2026 at 12:27:56 AM UTC-5 Jim Wilkerson wrote: >>> >>>> Hi, thanks for the tip. >>>> >>>> I removed the old reports in >>>> >>>> /var/www/html/weewx >>>> >>>> Reinstalled 5.2.0 (openSUSE 15.6 repos) >>>> >>>> Noticed that my weewx.conf was still >>>> >>>> # Do not modify this. It is used when installing and updating weewx. >>>> version = 4.10.2 >>>> >>>> Fixed that with the new weewx.conf from the 5.2.0 install >>>> >>>> # This configuration file was created by ... >>>> version = 5.2.0 >>>> >>>> As per >>>> >>>> https://www.weewx.com/docs/5.2/usersguide/where/ >>>> >>>> I set the skins to the absolute path on my system >>>> >>>> [StdReport] >>>> >>>> # Where the skins reside, relative to WEEWX_ROOT >>>> SKIN_ROOT = /usr/share/weewx/weewx_data/skins >>>> >>>> # Where the generated reports should go, relative to WEEWX_ROOT >>>> HTML_ROOT = /var/www/html/weewx >>>> >>>> The web page runs again (also had an Apache issue to resolve) but the >>>> Monthly reports still show the gaps as prevoius, example: >>>> >>>> MONTHLY CLIMATOLOGICAL SUMMARY for Nov 2025 NAME: Cary, NC USA ELEV: >>>> 348 feet LAT: 35-47.90 N LONG: 078-50.46 W TEMPERATURE (F), RAIN (in), >>>> WIND >>>> SPEED (mph) HEAT COOL AVG MEAN DEG DEG WIND DOM DAY TEMP HIGH TIME LOW >>>> TIME >>>> DAYS DAYS RAIN SPEED HIGH TIME DIR >>>> --------------------------------------------------------------------------------------- >>>> >>>> 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 >>>> 26 27 42.6 52.1 14:30 32.9 00:00 22.4 0.0 0.00 0.9 15.0 16:30 338 28 36.7 >>>> 46.2 14:00 28.8 07:30 28.3 0.0 0.00 0.9 18.0 10:30 329 29 34.9 45.5 14:00 >>>> 23.9 07:00 30.1 0.0 0.00 0.3 9.0 10:30 98 30 44.9 54.9 13:00 36.8 02:00 >>>> 20.1 0.0 0.25 0.1 7.0 14:00 304 >>>> --------------------------------------------------------------------------------------- >>>> >>>> 39.3 54.9 30 23.9 29 100.8 0.0 0.25 0.5 18.0 28 338 >>>> >>>> That data had been showing on the other system (which was mostly a >>>> mirror as this one) >>>> >>>> One thing I do notice though is before I was only seeing Monthly Data >>>> up to May 2023, now I see it 27 Dec 2024. >>>> >>>> I working on learning the sqlite syntax.... I assume the above command >>>> is a generic example... >>>> >>>> On Tuesday, January 20, 2026 at 4:22:24 PM UTC-5 Tom Keffer wrote: >>>> >>>>> Not a lot of information here, but assuming you're running the Seasons >>>>> report, and assuming that by "Monthly report" you mean the NOAA reports, >>>>> one thing you could try is deleting all of the generated files and let >>>>> WeeWX recreate them. This will ensure that what you're seeing is what is >>>>> truly in the database. >>>>> >>>>> As for seeing what records are in the database, that could be a very >>>>> long list indeed --- perhaps hundreds of thousands or even millions of >>>>> records. For a shorter summar, you could ask it for which months it has >>>>> any >>>>> record at all. Assuming that you are using SQLite and that you have the >>>>> tool "sqlite3" installed, use it to look inside the database. Assuming >>>>> that >>>>> you did a package install (not pip), then this would look like: >>>>> >>>>> *sqlite3 /var/lib/weewx/weewx.sdb* >>>>> sqlite> *select distinct >>>>> strftime("%Y-%m",dateTime,'unixepoch','localtime') from archive;* >>>>> sqlite> *.quit* >>>>> >>>>> Depending on how long you've been using your database, this could a >>>>> hundred lines or so. >>>>> >>>>> If you want even finer detail and wish to see which days have data, >>>>> you could do >>>>> >>>>> sqlite> *select distinct date(dateTime,'unixepoch','localtime') from >>>>> archive;* >>>>> >>>>> But be prepared, this could list thousands of lines. >>>>> >>>>> I've made a lot of assumptions above. If any are wrong come back with >>>>> more information. >>>>> >>>>> -tk >>>>> >>>>> On Mon, Jan 19, 2026 at 9:34 PM Jim Wilkerson <[email protected]> >>>>> wrote: >>>>> >>>>>> I recent had an event where I needed to move my weewx database to a >>>>>> different drive. >>>>>> >>>>>> I had first started the backup system, which had not been up since >>>>>> about May 2023. >>>>>> >>>>>> Once I copied the database over to the new location and restarted >>>>>> weewx, all starts but when I look in the web UI the Monthly Reports show >>>>>> no >>>>>> data from 28 May 2023 (the last time the system was apparently up, until >>>>>> 25 >>>>>> Nov 2025/ >>>>>> >>>>>> How can I list the database records to make sure they are intact, >>>>>> then get the historical data to be viewable once more on the Web UI >>>>>> reports? >>>>>> >>>>>> Weewx version 5.2.0 >>>>>> openSUSE LEAP 15.6 >>>>>> >>>>>> <code> >>>>>> # weectl database check >>>>>> Using configuration file /etc/weewx/weewx.conf >>>>>> Checking daily summary tables version... >>>>>> Daily summary tables are at version 4.0. >>>>>> Interval Weighting Fix is not required.</code> >>>>>> >>>>>> -- >>>>>> 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/4d2b261f-4c39-428f-92f4-4b804e9562cfn%40googlegroups.com >>>>>> >>>>>> <https://groups.google.com/d/msgid/weewx-user/4d2b261f-4c39-428f-92f4-4b804e9562cfn%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 visit https://groups.google.com/d/msgid/weewx-user/a0368397-1dc3-4846-b98c-330bc5dbb7afn%40googlegroups.com.
