Thread: Mass delete of unpopular tags
View Single Post
Old 07-21-2011, 01:45 PM   #5
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 31,079
Karma: 60358908
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Quote:
Originally Posted by jacr View Post
I found a way to do this. I did the following
1) Backed up the calibre database (metadata.db)
2) Downloaded SQLite Administrator
3) Ran the following SQL against the database:



This deleted all tags that are on less than 30 books.

That deletes the tags from the books (link)
What cleans up the tags table?
theducks is offline   Reply With Quote