I followed the instructions https://groups.google.com/d/msg/weewx-user/T2VuiIkcAEM/wZzemNzWknQJ but got a bunch of errors ... loke@loke:~/Downloads$ ls -l *sdb -rw-r--r-- 1 loke loke 16837632 sep 3 15:10 weewx.sdb -rw-r--r-- 1 loke loke 16439296 aug 28 05:55 wview.sdb
loke@loke:~/Downloads$ sqlite3 wview.sdb SQLite version 3.16.2 2017-01-06 16:32:41 Enter ".help" for usage hints. sqlite> .output wview.dump sqlite> .dump sqlite> .quit loke@loke:~/Downloads$ ls -l *sdb *dump -rw-r--r-- 1 loke loke 16837632 sep 3 15:10 weewx.sdb -rw-rw-r-- 1 loke loke 31878436 sep 3 15:27 wview.dump -rw-r--r-- 1 loke loke 16439296 aug 28 05:55 wview.sdb loke@loke:~/Downloads$ sqlite3 weewx.sdb SQLite version 3.16.2 2017-01-06 16:32:41 Enter ".help" for usage hints. sqlite> .read wview.dump Error: near line 3: table archive already exists Error: near line 4: UNIQUE constraint failed: archive.dateTime Error: near line 5: UNIQUE constraint failed: archive.dateTime Error: near line 6: UNIQUE constraint failed: archive.dateTime Error: near line 7: UNIQUE constraint failed: archive.dateTime Error: near line 8: UNIQUE constraint failed: archive.dateTime ... Den torsdag 26 december 2013 kl. 23:44:25 UTC+1 skrev Tom Keffer: > > Oops. Saw Vince's response after I posted my own. Good advice. > > These days, I'd say 90% of the answers to support questions can be found > in the manual or in the weewx Google group. > > -tk > > > On Thu, Dec 26, 2013 at 12:27 PM, vds <[email protected] <javascript:>> > wrote: > >> On Thursday, December 26, 2013 11:45:47 AM UTC-8, Simon wrote: >> >>> is it possible to use the wee_config_database command to merge two >>> weewx.sdb together? if so what is the commandline? >>> >>> >> Part of the fun of weewx is researching and learning stuff. Try searching >> the weewx forums newsgroup a little for "merging two sqlite databases" and >> read the thread that is found. >> >> >> - Tom answered the question from somebody else earlier this year - >> https://groups.google.com/d/msg/weewx-user/T2VuiIkcAEM/wZzemNzWknQJ >> >> >> - If you do the same query in Google, you get 113,000 hits :-) >> including this one, which is probably how I'd do it - >> http://stackoverflow.com/questions/14834613/merge-two-sqlite-files-on-osx >> >> >> If there are any matching records between the two databases you're >> merging, you'll see a bunch of complaining to the screen when you import >> the files, but all it'll be saying is that duplicate records were ignored, >> which is almost certainly exactly what you want anyway. Definitely never >> work off live copies, stop weewx and grab the database that's current and >> and work off offline copies just in case. >> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Weewx user's group" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> For more options, visit https://groups.google.com/groups/opt_out. >> > > -- 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]. For more options, visit https://groups.google.com/d/optout.
