Flush Dude historical data and export

RouterOS The Dude
1

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?

2

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

3

Same here. We have our Dude server running for more than 10 years (!).
We need a cleanup but need advice as well, how to.

4

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.