Importing collection data from 1.4 to 2.2.0

[Alan Ezust]

When I upgraded from 1.4 to 2.2, I think i tried every possible combination
of copy/import/rescan and never got ratings in properly.

So I wrote another program that scanned my 1.4 db and inserted the missing
ratings into a 2.2 db.
I was kinda curious to know how the new schema differed in any case.

I will attach the code that did it to this e-mail. I hope it helps some
others too.


On Mon, Nov 30, 2009 at 1:34 PM, Chris Joelly <chris-m-lists at joelly.net>wrote:

> Hello!
>
> i have upgraded to 2.2.0 and finally get used to the new version ;)
>
> but i have a question regarding importing the data from 1.4:
>
> i thought that "Importing collection" will import all data from my
> previous collection, but, as i read a thread from october on this list
> this is not the case. I catched on that thread that i have to rescan my
> collection from filesystem in any case.
>
> So, if i understood if correct, the best way to import the data is:
>
> 1. scan the filesystem
> 2. import the statistics
>
> hm. in 1.4 i used mysql to store data about my collection. and i want to
> use mysql again with 2.2.
>
> how to deal with the database issue in this context?
>
> the 1.4 scheme seems to be updated and useless for 2.2, so i can safely
> throw away the 1.4 db and create a new one for 2.2? I think no, the old
> db is needed for accessing parts of the old statistics?
>
> but i have to create a new database for the 2.2 db scheme upfront and
> configure the connection details before point 1, scanning the filesystem?
>
> is this the way the upgrade w.r.t the statistics should work smoothly?
>
> thx
>
> Chris
>
> _______________________________________________
> Amarok mailing list
> Amarok at kde.org
> https://mail.kde.org/mailman/listinfo/amarok
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/amarok/attachments/20091216/cb54645c/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ratingMigrate.tar.gz
Type: application/x-gzip
Size: 1771 bytes
Desc: not available
URL: <http://mail.kde.org/pipermail/amarok/attachments/20091216/cb54645c/attachment.gz>