Sometimes I move my files around, do a rescan collection, it updates perfectly (but obviously looses statistics). The statistics part is not a problem for now.

I see that my collection.db file is getting bigger and bigger. Just noticed that it's ~30MB in size, when at the start it was something like 10MB. No, I didn't get 3x more of new music files. After viewing database as text, I noticed a lot of old, renamed and moved entries in there. Any sugestions on how to clean up my database ?

I understand that the reason they're not removed is because some of those files might re-apear (nfs offline/online, dvd, etc) and their stats wouldn't be damaged.

BTW, I use SQLite backend

Rescan Collection just finished, no real change, old and non existant entries are still there =)

you're definitely using the most recent (1.4.4) version of amarok, right?

I have the same problem here, running amarok 1.4.4. Zillions of dead entries in my db that wont go away by rescanning...

dangle_wtf wrote:you're definitely using the most recent (1.4.4) version of amarok, right?

Yes, I'm running 1.4.4

I know it's sortof risky so be sure to keep a backup, but I've been having a lot of luck by going into collection.db and from the "directories" table I remove the dir name entry (and all subfolder entries) that I had already unchecked in Amarok (but had no effect), and then doing a full rescan.  Then all the songs in those dirs (in my collection.db) are gone, and my collection track count is right. 

Someday I intend to start with a new collection.db or start new with mysql, but in the meantime I'm trying to learn as much as I can about the collection.db, that and clean up my collection's tags and everything.  I'd really like to be able to transfer my ratings at least at that time..so doing a lot of playing around to see what I can get by with