Community discussions

MikroTik App
 
SergeS
Frequent Visitor
Frequent Visitor
Topic Author
Posts: 67
Joined: Fri Mar 25, 2016 6:23 am

How to clear all The_Dude's history?

Sat Jan 29, 2022 2:37 am

How to clear all history in The Dude? Cannot find...
 
User avatar
stmx38
Long time Member
Long time Member
Posts: 615
Joined: Thu Feb 14, 2008 4:03 pm
Location: Moldova, Chisinau

Re: How to clear all The_Dude's history?

Sat Jan 29, 2022 7:16 pm

Not sure if something like this exists.

We probably can we disable dude, remove it's folder from the disk and enable dube back. But this will remove also all devices and settings.
 
User avatar
stmx38
Long time Member
Long time Member
Posts: 615
Joined: Thu Feb 14, 2008 4:03 pm
Location: Moldova, Chisinau

Re: How to clear all The_Dude's history?

Mon Feb 21, 2022 10:47 pm

This post have something interesting:
try this on file from DOS command line:
DOS code

C:\Users\Rextended\Desktop\BACKUP\dude>sqlite3 dude.db VACUUM

C:\Users\Rextended\Desktop\BACKUP\dude>sqlite3 dude.db
SQLite version 3.33.0 2020-08-14 13:23:32
Enter ".help" for usage hints.
sqlite> delete from outages;
sqlite> delete from chart_values_raw;
sqlite> delete from chart_values_10min;
sqlite> delete from chart_values_2hour;
sqlite> delete from chart_values_1day;
sqlite> VACUUM;
sqlite>.quit

C:\Users\Rextended\Desktop\BACKUP\dude>


After that fresh start dude service, after full start, stop dude service, after full stop, replace the modified dude.db with the cleaned one, restart dude service

Who is online

Users browsing this forum: Majestic-12 [Bot] and 10 guests