Importing collection data from 1.4 to 2.2.0

[Alan Ezust]

Forget the last e-mail, with the attachment. Here is a URL to a better
tarball that contains a readme too.

http://localhost/share/ratingMigrate.tar.gz


On Wed, Dec 16, 2009 at 10:21 AM, Alan Ezust <alan.ezust at gmail.com> wrote:

> 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/cc2fefbe/attachment.html>