How about doing a dump of the v3.9 database, then delete the CREATE TABLE statement. Then import into the V4 database.
Something like: # Create a dump, then strip out the CREATE TABLE echo ".dump" | sqlite3 weewx3.92.sdb | sed -e 's/^CREATE TABLE//' > weewx3.92.sql # Use the results to insert into the V4.0 table sqlite3 weewx4.0.sdb < weewx3.92.sql One thing I want to stress is that there is no difference between a V3.9 database and a V4.0 database. The only difference is that V4.0 offers a new, extended schema. -tk On Sun, May 17, 2020 at 6:55 AM Ron Sell <[email protected]> wrote: > I upgraded to a new Pi and weewx 4.0. > > Old Pi > weexwx 3.9.2 > Database extended for more observations > 58 columns > Running for a year > > New Pi > Weewx 4.0 > Database not extended Included all of the observstions i needed in the new > version.' > 113 columns > > What is the best way to keep all my old data? > > > I can't just copy the old database 1 for 1 since they are different. > > thanks > > > -- > 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/378b9004-78d2-4a80-bccb-27b35ecdc64c%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/378b9004-78d2-4a80-bccb-27b35ecdc64c%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/CAPq0zEAL8auPoQODgMaMgepLgt9HLGDdMb-0goiLESJdt%2BEQvw%40mail.gmail.com.
