Hello. Mikrotik router with Dude takes time from GPS receiver. And for one moment GPS supply “2026 year january 1st” date to router.
Later GPS was restored and date and time are correct, but impact was bad.
Please see picture.
.
So, how may I clean/purge all stored data from DB?
I need to keep all config, of course
I downloaded database to Windows PC.
7-zip extracted it. File header looks like “dude.db xxxxxxxx SQLite format 3”
If you cut 1FF bytes from DB start, it will opened by any SQLite tools. So, Dude DB almost standard DB, but not.
Anyway, I did vacuum on router itself:
[admin@R0B] /dude> vacuum-db file=nvme1/dude/dude.db
But this does not delete statistics from DB.
This thread discuss exactly deleting statistics http://forum.mikrotik.com/t/dude-db-vacuuming/131375/1 , but since DB can not be opened on PC without cutting header, and I do not know what stored in this header, may be checksum for db?
So, I deleted header, got normal DB, removed historical data as was proposed in mentioned thread. inserted back header. Dude does not start.
Looks like header has control checksum to protect Dude form People.
FYI: DB Header
Good job it doesn’t. It never does and never will. Why do people think vacuum is just going to delete some data or other from the tables?
Did you actually read up what the command does before running it?
No, I thought not.