https:\/\/www.sqlite.org\/download.html<\/a>. Simply get the precompiled binary for your OS. For ease of sake Put your SQLite3 .exe in the same director as your dude database. This makes commands much simpler.<\/p>\nFollow these steps to clean the database:<\/p>\n
1. Stop Dude service
\n Make sure to kill the dude process. Simply closing out of it does not fix. I had to go into task manager and end \u201cdude.exe\u201d
\n2. Dump DB to text with SQLite. (echo .dump | sqlite3.exe dude.db > dude.sql)
\n3. Rename dude.db, delete any dude.db-journal and dude.viw files. Something like dude.db.old
\n4. Start Dude service, this should create a new, blank dude.db
\n5. Stop Dude service
\n6. Open the dude.sql you created in step 2. Delete everything from dude.sql except for the lines that say INSERT INTO “objs” (including the lines that create the tables and indexes and stuff, just the INSERT INTO “objs” lines should be left)
\n7. Open dude.db with SQLite and delete everything from the objs table (DELETE FROM objs;)
\n8. Read old objs values into new DB (.read dude.sql)
\n9. Start Dude service<\/p>\n
20,000 records took me a few hours to read back in. Just let it run. If you are curious on progress have the window open with the dude.db file. You should see the size of it growing during the read process.<\/p>\n","protected":false},"excerpt":{"rendered":"
So as installs of the Dude v4beta are aging they are experiencing some database issues. This is due to a 2gig limit of the SQL version embedded with the Dude. So, if your dude database is crashing, complaining about being full, or just plain running slow it may be time for a cleaning. You can […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[1],"tags":[239,236,240,39,237,235,238],"jetpack_publicize_connections":[],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p6VLMf-3H","jetpack-related-posts":[{"id":1080,"url":"http:\/\/www.mtin.net\/blog\/sql-lite-all-you-wanna-know\/","url_meta":{"origin":229,"position":0},"title":"SQL Lite: All you wanna know","author":"j2sw","date":"April 4, 2016","format":false,"excerpt":"Awhile back i did an article on cleaning the Dude database. \u00a0Alex Nordeen has a very in-depth article on SQL Lite and it's many features. \u00a0Check out the article and Guru99.com for more stuff.","rel":"","context":"In \"database\"","block_context":{"text":"database","link":"http:\/\/www.mtin.net\/blog\/tag\/database\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":414,"url":"http:\/\/www.mtin.net\/blog\/dude-not-upgrading-beyond-ros-6-24\/","url_meta":{"origin":229,"position":1},"title":"Dude not upgrading beyond RoS 6.24","author":"j2sw","date":"November 12, 2015","format":false,"excerpt":"So a problem has come up with folks who use the Dude for upgrades. Ever since 6.24 The Dude has been having problems pushing upgrades out to devices. The error message you get is \"Can not determine packages\". This seems to be a known issue according to this post.","rel":"","context":"In "Mikrotik"","block_context":{"text":"Mikrotik","link":"http:\/\/www.mtin.net\/blog\/category\/mikrotik\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":197,"url":"http:\/\/www.mtin.net\/blog\/post-show-specials\/","url_meta":{"origin":229,"position":2},"title":"Post Show Specials","author":"j2sw","date":"October 17, 2014","format":false,"excerpt":"MTIN is offering some post WISPAPALOOZA specials -Dude monitoring Instance. Bring up your own external Dude service for monitoring your network. $20 a month with a free setup ($400 value) -Hosted Spam Filtering for 1 domain $12 per month. 99.99% accurate -Backup DNS Services $10 per month. These specials are\u2026","rel":"","context":"In "News"","block_context":{"text":"News","link":"http:\/\/www.mtin.net\/blog\/category\/news-2\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":172,"url":"http:\/\/www.mtin.net\/blog\/brothers-wisp-19\/","url_meta":{"origin":229,"position":3},"title":"Brothers WISP #19","author":"j2sw","date":"September 16, 2014","format":false,"excerpt":"","rel":"","context":"In "Data Center"","block_context":{"text":"Data Center","link":"http:\/\/www.mtin.net\/blog\/category\/data-center\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2885,"url":"http:\/\/www.mtin.net\/blog\/mikrotik-vulnerability\/","url_meta":{"origin":229,"position":4},"title":"Mikrotik Vulnerability","author":"j2sw","date":"February 25, 2019","format":false,"excerpt":"On February 2 a CVE issue was published, describing a vulnerability, which allows to proxy a TCP\/UDP request through the routers Winbox port if it's open to the internet. A fix has already been released on February 11, 2019 in all RouterOS release channels. Please keep your device up to\u2026","rel":"","context":"In \"mikrotik\"","block_context":{"text":"mikrotik","link":"http:\/\/www.mtin.net\/blog\/tag\/mikrotik-2\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":522,"url":"http:\/\/www.mtin.net\/blog\/lots-of-changes-in-routeros-6-34\/","url_meta":{"origin":229,"position":5},"title":"Lots of changes in RouterOS 6.34","author":"j2sw","date":"January 29, 2016","format":false,"excerpt":"Lots of changes in RouterOS 6.34 Some Standouts that will be of benefit to alot of folks I know *) mipsle - architecture support dropped (last fully supported version 6.32.x); *) btest - significantly increased TCP bandwidth test performance; *) ssh - fixed possible kernel crash; *) crs212 - fix\u2026","rel":"","context":"In "Mikrotik"","block_context":{"text":"Mikrotik","link":"http:\/\/www.mtin.net\/blog\/category\/mikrotik\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"http:\/\/www.mtin.net\/blog\/wp-json\/wp\/v2\/posts\/229"}],"collection":[{"href":"http:\/\/www.mtin.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.mtin.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.mtin.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.mtin.net\/blog\/wp-json\/wp\/v2\/comments?post=229"}],"version-history":[{"count":2,"href":"http:\/\/www.mtin.net\/blog\/wp-json\/wp\/v2\/posts\/229\/revisions"}],"predecessor-version":[{"id":419,"href":"http:\/\/www.mtin.net\/blog\/wp-json\/wp\/v2\/posts\/229\/revisions\/419"}],"wp:attachment":[{"href":"http:\/\/www.mtin.net\/blog\/wp-json\/wp\/v2\/media?parent=229"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.mtin.net\/blog\/wp-json\/wp\/v2\/categories?post=229"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.mtin.net\/blog\/wp-json\/wp\/v2\/tags?post=229"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}