I'm reorganizing the directory structure on my HDs and I'd like to move my music directory to another location. Is there any way to do so without destroying all entries in my amaroK database (ie. times played, ratings, etc)?

(NOTE: I don't want to use a symlink.)

Hi,
perhaps this script would help:
http://www.kde-apps.org/content/show.php?content=40008
It should help you moving your collection without loss of data.

Greetings

m0nk

Many thanks, I'll try it out!

Ugh, that wasn't really what I was looking for.

I think I'm better off manipulating the database directly. That's probably not too hard.

Doesn't amarok have a "Reorganize" option in the context menu?  This should work (I'm not sure - never tried) and it let's you customize the directory structure, filenames, and destination directory.

This should do the job, yes. Though, it is almost too sophisticated as it can do much more than just moving.
Try the Manage_Files->Organize_X_Files dialog, get to "Details" and do whatever you want.

Hi,
sorry, but I can't find "Reorganize" in the context menu.
Is it in the menu of the playlist or the collection?

Greetings

m0nk

Amarok 1.4.1 will have a feature where when you move a file, Amarok will recognize this and transfer stats etc.

Dieter Schroeder wrote:Hi,
sorry, but I can't find "Reorganize" in the context menu.
Is it in the menu of the playlist or the collection?

Greetings

m0nk

You do this from the Collection tab, but unfortunately the songs lose their stats when you move them.  Lame.

Amarok 1.4.1 will have a feature where when you move a file, Amarok will recognize this and transfer stats etc.

dangle_wtf wrote:Amarok 1.4.1 will have a feature where when you move a file, Amarok will recognize this and transfer stats etc.

Woohoo!   It's about time I moved all my music to a new directory... I'm getting tired of seeing "iTunes Music" in all my music paths!

Any SQL experts here? I'm trying to edit paths in my collection.db through the command-line SQLite client, but so far I'm not making any progress.

For example, here I want to change the beginning of `dir` on all rows in table `directories` from "/stuff/music" to "/home/walrus/music":
update directories set dir = '/home/walrus/music' || substr(dir, length('/stuff/music'), length(dir) - length('/stuff/music'))
where dir like '/stuff/music/%';
I get a message "SQL error: column dir is not unique". Not sure what the hell that's supposed to mean...

I don't really know much at all about SQL, but I do know that collection.db uses a "url" field for each track in your collection.  I think this is how all the different tables are related.  You'll probably need to change the url data for each track, will you not?