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.