Month: October 2009

Recent Posts

Importing Amarok 1.4 statistics into Amarok 2.2

This assumes you use mysql/external:

* Save your amarok <2.2 database:

mysqldump -uroot -p amarok > amarok.db #adjust for your system

* Re-import it as database “amarok1”
* Drop your original amarok database and let Amarok 2.2 otherwise re-create it.
* Look at amarok.urls.rpath and amarok1.statistics.url to determine the prepending path difference

Execute the following queries:

UPDATE amarok1.statistics SET url=REPLACE(url,"./", "./mnt/hdd750/"); /* replace "./mnt/hdd750/" with the prepending difference you saw in the earlier step */
 
INSERT INTO amarok.statistics (url,createdate,accessdate,score,rating,playcount,deleted) SELECT id,createdate,accessdate,percentage,rating,playcounter,deleted FROM amarok1.statistics s1 INNER JOIN amarok.urls u2 ON(s1.url=u2.rpath);

Preseto, Amarok 2.2 now has your old statistics.