I would convert a ‘copy’ of the old small schema db to the new bigger schema, do a db dump of the archive table from that after it is updated, then do a db restore of the updated old db into a ‘copy’ of the new bigger schema db. You’ll need to rebuild daily when you’re done. See the wiki for info there.
https://github.com/weewx/weewx/wiki/Switching-to-the-new-wview_extended-schema has how to do the conversion offline. Basically copy your weewx.conf to another name (updatedb.conf or whatever) then run the weectl database reconfigure command and specify the —config option. You should likely change the filename in your .conf file to not alter your running db. Unfortunately the weectl database command does not have a simple —dbfilename or equivalent switch so you need to do a little sleight of hand. Email me if I lost you there or if you need help with getting the old db updated. It’s easier than it sounds. On Friday, October 16, 2026 at 10:15:32 AM UTC-7 John Matz wrote: > I upgraded to WeeWX 5.5.0-1back in the August / September 2026 time > frame. I am using a RPi 3B with Bookworm. Prior to the update, I backed > up the database to a remote drive. The issue is that the original database > had 52 tables and the Archive had 52 columns. The new database has 114 > tables and the Archive has 115 columns. What is the best means to combine > the historical data into the new database? -- 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/47e2f7d4-2a04-4b4e-ad43-c2b5d7a992ecn%40googlegroups.com.
