Community discussions

MikroTik App
 
hytanium
Member Candidate
Member Candidate
Topic Author
Posts: 201
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: 1619
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: 124
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.
 
Dude2048
Member Candidate
Member Candidate
Posts: 212
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 10 guests