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
