Quote:
Originally Posted by arad26
Could you please explain step by step how to make this on the pw 2? Thank you
|
I've got PW1, so I don't know if PW2 has different db, but I doubt it so you try and do as I've said.
If you've got linux or mac, skip this step, your OS will have this program already, if not, download it.
1. Go to
https://sqlite.org/download.html and download
Precompiled Binaries for ___
sqlite-shell-
linux-x86-3080403.zip
sqlite-shell-
osx-x86-3080403.zip
sqlite-shell-
win32-x86-3080403.zip
2. Unarchive it.
3. I strongly suggest you copy [mounted Kindle device]/system/vocabulary/vocab.db to different dir just in case.
4. Open command line / shell / cmd.exe in dir where you have vocab.db and sqlite3 / sqlite3.exe
5. Run commands to achieve what do you want: (change sqlite3 to sqlite3.exe on windows)
this removes mastered words (if you want to remove only them)
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';"
If you want complitly reset vocabluary run all three commands.