Community discussions

 
hytanium
Member Candidate
Member Candidate
Topic Author
Posts: 199
Joined: Thu Jan 18, 2007 9:10 pm

Flush Dude historical data and export

Sun Feb 12, 2012 4:10 pm

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?
 
lebowski
Forum Guru
Forum Guru
Posts: 1616
Joined: Wed Aug 27, 2008 5:17 pm

Re: Flush Dude historical data and export

Tue Feb 14, 2012 4:00 pm

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
 
mip
Member Candidate
Member Candidate
Posts: 122
Joined: Fri Jun 04, 2004 8:19 pm
Location: Ráckeve
Contact:

Re: Flush Dude historical data and export

Wed Dec 19, 2018 9:47 am

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?
Same here. We have our Dude server running for more than 10 years (!).
We need a cleanup but need advice as well, how to.
https://www.youtube.com/watch?v=j7q0Y_JZMrg - the country you must visit
 
Dude2048
Frequent Visitor
Frequent Visitor
Posts: 52
Joined: Thu Sep 01, 2016 4:04 pm

Re: Flush Dude historical data and export

Wed Dec 19, 2018 1:44 pm

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.

Who is online

Users browsing this forum: No registered users and 5 guests