Community discussions

MikroTik App
 
pmattia90
just joined
Topic Author
Posts: 11
Joined: Thu Jun 08, 2023 12:08 pm

Trying to open dude DB

Thu Jun 05, 2025 9:49 am

Hello,
i'm trying to open dude db exported from two different router on 7.16, but unfortunately when i try to using sqlite3, it returns that this file is not a database.
I want to open it since in the past i made some shrinking and cleaning of DB thanks to guide posted which tells that deleting historical data will reduce the size of DB.
I have also some problem regarding dude, when i remove a dependencies, it crashes.
Thanks a lot for your support.
 
User avatar
voljka
newbie
Posts: 48
Joined: Tue Oct 27, 2009 4:34 pm

Re: Trying to open dude DB

Fri Jun 06, 2025 3:20 pm

You can not do this. DB has Mikrotik appended header, which IMHO has checksum for real SQLite DB. If you cut this header, you will get normal DB, but this is the end. Dude does not start edited DB with same old header.
Cut this part to gen normal DB
Dude DB Header.png
You do not have the required permissions to view the files attached to this post.