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