Corrupted Database

RouterOS The Dude
1

It appears that my dude.db is seriously corrupted.

When I start sqlite3 and do a vacuum, I’m told “Error: string or blob too big”.

When I export the .db to a .sql, the created file decreases in size by about 40%.
sqlite dude.db > file.sql is the command I used.

When I then try and convert the .sql file back to a .db file I keep on getting a file with zero filesize. ie The reverse conversion just won’t work.
sqlite3 file.sql < newdude.db is the command that I used.

Does anyone have any ideas how I can recover / rebuild the database?

2

Look at your sql file in a text editor and see if there is anything that looks corrupted, then see if you can manually fix it.

3

88MB.

1124704 lines. It’s going to be quicker to use a clean room approach and redo the maps from scratch.