Hmmm, that sounds odd. I just tried it on my MacBook Air (admittedly, a faster machine) with 970k records and the check took 63 seconds. It should show a progress indicator as it goes.
I don't completely trust browser-based sqlite editors, but you've got nothing to lose if you backup the database first. An alternative is to use the sqlite3 <https://www.sqlite.org/cli.html> tool on the database with the new weewx data. Use the ".dump" command, saving the results to a file. The results will be a bunch of SQL statements. Massage the results to strip the "CREATE TABLE" stuff at the beginning, then feed the left over INSERT commands into sqlite3 using the target database. -tk On Thu, Jan 25, 2018 at 4:45 PM, 'loonsailor' via weewx-user < [email protected]> wrote: > I'm running it now with check-strings. Taking a looooong time. > Extrapolating out, looks like it could be 24 hours or so for 11 years of > data (537K records). Is that normal? (1.6 GHz Celeron N3150, 4GHz ram) > > Also, once its done (assuming it works) I was planning on merging the last > month of data that weewx has gathered with the repaired wiew database using > "DB Browser for SQLite", by exporting the records from weewx.sdb and then > importing into the wview archive, both of which the browser does as text, > then renaming the wview database weewx.sdb and restarting it. Anything > wrong with that plan? > > > > On Wednesday, January 24, 2018 at 11:43:54 PM UTC-8, gjr80 wrote: >> >> On Thursday, 25 January 2018 16:15:03 UTC+10, loonsailor wrote: >>> >>> It's getting late. so I'll try this in the morning. >>> >> >> Generally a good idea to manipulate a database with a clear head (and >> eyes) :) >> >> Gary >> > -- > 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. > -- 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.
