Flush Dude historical data and export
We have been using the dude for 5 years now, unfortunately, it is crashing almost daily and has become unreliable. Is there a way for us to export ONLY the monitored devices and then import them into a new dude installation? Or, is there a way for us to flush all remembered data and charts to maybe clean up the installation?
Re: Flush Dude historical data and export
I noticed that if you Ctrl-C a device it clears the history (this must be in preparation for the copy) . I don't know if it would fix the trouble. Make sure to backup before doing interesting things.
HTH,
Lebowski
HTH,
Lebowski
Re: Flush Dude historical data and export
Same here. We have our Dude server running for more than 10 years (!).We have been using the dude for 5 years now, unfortunately, it is crashing almost daily and has become unreliable. Is there a way for us to export ONLY the monitored devices and then import them into a new dude installation? Or, is there a way for us to flush all remembered data and charts to maybe clean up the installation?
We need a cleanup but need advice as well, how to.
Re: Flush Dude historical data and export
Can't find the internet page right now, but it was sqllite 3 and;
sqlite3 dude.db
DELETE FROM outages;
DELETE FROM chart_values_raw;
DELETE FROM chart_values_10min;
DELETE FROM chart_values_2hour;
DELETE FROM chart_values_1day;
pragma integrity_check;
vacuum;
reindex;
.quit
Edit: http://www.mtin.net/blog/cleaning-the-dude-database/
This and the comment on that page.
sqlite3 dude.db
DELETE FROM outages;
DELETE FROM chart_values_raw;
DELETE FROM chart_values_10min;
DELETE FROM chart_values_2hour;
DELETE FROM chart_values_1day;
pragma integrity_check;
vacuum;
reindex;
.quit
Edit: http://www.mtin.net/blog/cleaning-the-dude-database/
This and the comment on that page.
Who is online
Users browsing this forum: No registered users and 2 guests