MikroTik

I’ve had a problem Dude 4.0beta3 database for a year now. dude.db was 419259 KB in size.

Trying the dump to .sql solution caused all my maps to disappear.

Instead, I did the following:

1. Shutdown dude.exe
2. Make a backup of dude.db
3. Use sqlite3 dude.db
4. sqlite> DELETE FROM outages;
5. sqlite> DELETE FROM chart_values_raw;
6. sqlite> DELETE FROM chart_values_10min;
7. sqlite> DELETE FROM chart_values_2hour;
8. sqlite> DELETE FROM chart_values_1day;
9. sqlite> pragma integrity_check;
10. sqlite> vacuum;
11. sqlite> reindex;
12. sqlite> .quit
13. Start dude.exe again

My dude.db is now 46662 with all maps minus all historic outages and charts. It runs fast.

Great. But it should be running fast with all historic data...

Nice to know how to clear out the database!

I have a problem with my dude , it stop working now when i check the this command here is the result:
/dude print
action timed out - try again, if error continues contact MikroTik support and send a supout file (13)

so i download the database and delete all historic data it reduce the database size from 260MB to 20 MB
but still when i enable the dude and run the /dude print it shows it is loading the record and then it hangs again(check the attachment)

it seems there is a line in database which crashes the dude
when i dump the database i have 43427 records in obj table

anyway thoughts about how i can fix this?

Thank you

Sorry to hear that you are having trouble with your Dude install.

Did you try the vacuum command?