Before you follow Vince's suggestion, I would do something simpler: just copy over the weewx.sdb file and use it untouched. SQLite files are supposed to be portable across all architectures.
See https://www.sqlite.org/onefile.html >From experience, I know this is not always true, but there's a 90% chance it will work out. -tk On Tue, Dec 29, 2020 at 11:30 AM vince <[email protected]> wrote: > I do it manually via dump and restore using sqlite3... > > - Stop weewx > - Make a copy of your old and new db and work off those copies > - cp weewx.sdb /var/tmp/weewx.new.sdb > - cp your_old_weewx.sdb /var/tmp/weewx.old.sdb > - cd /var/tmp > - Dump your old database's archive table to a file > - echo ".dump archive" | sqlite3 weewx.old.sdb > old.dump.txt > - Restore that into your new database > - "cat old.dump.txt | sqlite3 weewx.new.sdb" > - (and ignore the 'table already exists' warning) > - Rebuild your daily summaries > - rename your production weewx.sdb file to something else > - copy the weewx.new.sdb built above into place as weewx.sdb in the > directory weewx expects it in > - sudo wee_database --rebuild-daily > - Start weewx > > ALWAYS save your original files just in case....never work off your > originals..... > > The stuff above is loosely tested but should work ok. > Again, ALWAYS save your original files just in case something goes > sideways. > > On Tuesday, December 29, 2020 at 9:49:40 AM UTC-8 [email protected] wrote: > >> I've moved my weewx to a new host. I have the previous weewx.sdb file. >> Is the wee_import utility the answer? How can I bring the old data into >> the new sdb file? >> >> thanks, >> -Keith >> > -- > 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/ead85a80-686d-4c3e-a9d1-aa7ff291eeb2n%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/ead85a80-686d-4c3e-a9d1-aa7ff291eeb2n%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/CAPq0zEA-3kURzr%2BO2m8M6raxjMUqUmMC3p1u752V97c6ne2G%2BQ%40mail.gmail.com.
