How do I remove all the existing data and start again?

[Dave Jeffries]

Have searched but not found an easy solution to resetting the database.
I have been running weewx version 3.1 using the simulator  and then connected my real ws23xx weather station.
How do I get rid of all the simulator data and start again?
Cheers
Dave

[Thomas Keffer]

You did not say what installation method you used. In any case, uninstall instructions are included in the appropriate document that covers installation. See the User's Guide, section Installation methods for a list of these documents.

-tk

--
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 weewx-user+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Dave Jeffries]

I used the setup.py method, just thought there may be a simple command  to remove all the existing data.
I guess the weewx.conf and skin.conf will be overwritten so will have to take a copy first?

[mwall]

On Sunday, July 12, 2015 at 5:16:55 PM UTC-4, Dave Jeffries wrote:

I used the setup.py method, just thought there may be a simple command  to remove all the existing data.
I guess the weewx.conf and skin.conf will be overwritten so will have to take a copy first?

if you do not care about any of the data in the database, then just stop weewx, delete the database file (/home/weewx/archive/weewx.sdb), then start weewx.

if you want to surgically remove data from the database, do something like this:

sqlite3 /home/weewx/archive/weewx.sdb
sqlite> delete from archive where dateTime < X;

where X is the timestamp (unix epoch) after which you started collecting data from the real weather station.

m

[Dave Jeffries]

Excellent thank you, thats exactly what I was looking for!

[George Alexander]

After trying the "Delete weewx.sdb" method for a refresh, when I restarted weewx, the syslog showed it happily re-populating the database with all my old data - where on earth did it get that from and how do I stop it doing it again?

[Thomas Keffer]

Magic. :-)

Your hardware must have an onboard logger. If you truly want a fresh start, you'll have to clear it. Specific instructions depends on the make of your hardware.

-tk

--

[George Alexander]

Haha magic indeed!

I completely overlooked the internal logger in the station itself - thanks very much for that.

[S R]

I've got the same problem. finished testing with the simulator, deleted the db and created again. 

cleared the browser cache on both chrome and firefox, but i goto the page and it shows 28.01 even though today is 25.01 and the data from when the simulator run

[gjr80]

Did you delete any previously generated reports on both your WeeWX machine and web server?

Gary

[S R]

I just deleted the .sdb and then run wee_database --create.

i don't see any cache data for nginx on either the ubuntu or freebsd versions i setup for testing, but they both show the same problem

[p q]

There are .html pages on the web server public directory that your seeing

To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/b467bb52-8601-4f17-b840-992cf2339888n%40googlegroups.com.

[S R]

deleted the entire html directory and run wee_reports and it is back with the simulator data... even though a db we deleted and created again

[gjr80]

Delete the html directory again (definitely on the WeeWX machine and also delete the html/png files on your web server if applicable), delete the database and restart WeeWX. Monitor the log, confirm a new database is created (it will be logged) and which driver is being used. Confirm report generation. If you still get old simulator data in a browser it’s a browser cache issue or you have more than one WeeWX instance running or remnants from another WeeWX instance. You can also take the browser out of the equation and view the report output in an editor or cat it to your console.

Gary

[S R]

done that mulitple times already....and more weirdness.....

index web page is good - shows correct todays date (sessions template out of box)

day is good - shows todays date

week/month/year - shows date of 31.01 with simulator data.

[gjr80]

What skin are we talking about Seasons? Standard or something else. ‘Index page has correct date’ what about observations? Plots? ‘week/month/year - shows date of 31.01 with simulator data’ so date is wrong but is data correct. What do the plots show? What is the timestamp under the x axis of the plots? Seeing a startup log after deleting everything would help. What about time stamps on generated files? Is there a link to your site?

You are looking at your pages we are not, so you need to give us a detailed picture.

Gary

[S R]

yes. i did fresh install (Standard Seasons skin) with the simulator to make get it working. Then i added the interceptor driver.

Simulator in generator mode created data up to 31.01.21. I have the ecowitt unit inside, so only inside temperature, humidity and pressure is being sent at the moment.

index.html page time/date is showing correct. inside temp/hum is correct and all other values are NA/0

day graphs are showing correctly for the collection time the system has been up. as in today 26.01

week/month/year graphs are still showing plots for 26 -> 31.01.21

[gjr80]

Sounds like all is fine except for week/month/year plots? By default week plots are generated once per hour, month every three hours and year every 24 hours. Did you delete all of the generated plot image files (xxx.png)? This forces WeeWX to regenerate them all on the next report cycle.

Gary

[S R]

all is good now.... only there is no pressure. i think this is because the skin is using barometer, but the ecowitt is directing baromabsin to pressure