Copy the dude.db from the file folder in your routerboard to the same fold you’ve extracted sqlite3. Best to rename the dude.db to dude.orig.db so you won’t have to change it later when you copy the newly created file back from the router.
Delete dude.db from the routerboard, start the dude back up to create a new, blank dude.db file. Copy that to the same folder you were working with previously.
sqlite3.exe dude.db
pragma integrity_check
delete from objs;
.read objs.sql
.quit
this is not worked for me.. can you explain more ? I could not do this, it gives me an error. did i made mistake ?
here is output;
C:\test2>sqlite3.exe dude.orig.db
SQLite version 3.21.0 2017-10-24 18:55:49
Enter “.help” for usage hints.
sqlite> .output objs.sql
sqlite> .dump
sqlite> .exit
C:\test2>sqlite3.exe dude.db
SQLite version 3.21.0 2017-10-24 18:55:49
Enter “.help” for usage hints.
sqlite> pragma integrity_check;
ok
sqlite> delete from objs;
sqlite> .read objs.sql
Error: near line 3: table objs already exists
Error: near line 8320: table outages already exists
Error: near line 55843: table chart_values_raw already exists
Error: near line 1607798: UNIQUE constraint failed: chart_values_raw.sourceIDand
Time
Error: near line 1607946: UNIQUE constraint failed: chart_values_raw.sourceIDand
Time
Error: near line 1607948: table chart_values_10min already exists
Error: near line 23445783: table chart_values_2hour already exists
Error: near line 32580225: UNIQUE constraint failed: chart_values_2hour.sourceID
andTime
Error: near line 32580227: table chart_values_1day already exists
Error: near line 34018504: index outages_idx_serviceID_time already exists
Error: near line 34018505: index outages_idx_deviceID_time already exists
Error: near line 34018506: index outages_idx_mapID_time already exists
sqlite> .quit
C:\test2>
after finish this job objs.sql created and nearly 2.2gb . what should i do after this job ? dude.orig and dude database files still in same folder. which file should i use ?