MobileRead Forums - View Single Post

dtp · 04-18-2014, 01:13 AM

There is db file in /system/vocabulary/vocab.db
If you remove the file and restart kindle it won't help, file will be downloaded from Amazon, but if you alter db and after restart kindle it will do.

To alter db use these commands:

this removes mastered words
sqlite3 vocab.db "DELETE FROM WORDS where category=100;"
this will remove not mastered words
sqlite3 vocab.db "DELETE FROM WORDS where category=0;"
this removes word references to books
sqlite3 vocab.db "DELETE FROM LOOKUPS where id!='blabla';"

sqlite3 you can download from https://sqlite.org/download.html
linux or mac most certainly will have it installed.

04-18-2014, 01:13 AM	#15
dtp Member Posts: 21 Karma: 9432 Join Date: Apr 2014 Device: Kindle PW1	There is db file in /system/vocabulary/vocab.db If you remove the file and restart kindle it won't help, file will be downloaded from Amazon, but if you alter db and after restart kindle it will do. To alter db use these commands: this removes mastered words sqlite3 vocab.db "DELETE FROM WORDS where category=100;" this will remove not mastered words sqlite3 vocab.db "DELETE FROM WORDS where category=0;" this removes word references to books sqlite3 vocab.db "DELETE FROM LOOKUPS where id!='blabla';" sqlite3 you can download from https://sqlite.org/download.html linux or mac most certainly will have it installed.