Quote:
Originally Posted by timlevin
dtp --
I ran these two instructions, only, because I wanted to preserve the mastered words:
Code:
# 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';"
After I ejected the Kindle and reset it, I was a little surprised that the mastered words were deleted, in addition to the not mastered and book-related words.
Do you have any idea what I did wrong to remove the mastered words? |
You've most likely executed the wrong line. If you've Firefox installed on your machine, you can use the free
SQLite Manager addon to delete entries in a more controlled manner. (Since SQLite Manager searches only for databases with an .sqlite extension by default, you'll need to select
All files (*.*) from the file type drop-down list box.)
In SQLite Manager, select the
Words table, click
Browse & Search and delete the entries that you no longer need. (You can sort by status or language, by clicking the
category or
lang column headings.)
It goes without saying that you may want to create a backup of vocab.db before modifying it with SQLite Manager.