Thanks, I did the data dump. Its now an SQL file. How do I get it into the weewx4.0 database?
thanks On Sun, May 17, 2020 at 11:06 AM Tom Keffer <[email protected]> wrote: > 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 > <https://groups.google.com/d/msgid/weewx-user/CAPq0zEAL8auPoQODgMaMgepLgt9HLGDdMb-0goiLESJdt%2BEQvw%40mail.gmail.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/CABn15dYbjnGtZ%3DaNSCqrYhCBpw56uN%3DAfKYWPuxhQ7ZVF2i48Q%40mail.gmail.com.
