I added all of the Data to my new database. It imported usinf the .SQL. I rn a query on the archive table SQLite: select count(*) from archive and all 80,000 records are in there.
None of my reports reflect it. ran sudo wee_reports On Sunday, 17 May 2020 11:06:12 UTC-4, Tom Keffer 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] <javascript:>> > 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] <javascript:>. >> 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/cebbe173-4337-4cde-8af6-94eb809a83f3%40googlegroups.com.
