[prev in list] [next in list] [prev in thread] [next in thread] 

List:       amarok
Subject:    Re: just lost all my ratings after running the latest git of amarko
From:       Bart Cerneels <bart.cerneels () kde ! org>
Date:       2012-10-16 6:22:01
Message-ID: CAMnMsSeexxU0sOndXeGxdjqmCpndnVjZXxipP9Xdida6cyp3pw () mail ! gmail ! com
[Download RAW message or body]

On Tue, Oct 16, 2012 at 1:32 AM, Alan Ezust <alan.ezust@gmail.com> wrote:
>
>
> On Mon, Oct 15, 2012 at 12:32 PM, Matěj Laitl <matej@laitl.cz> wrote:
>>
>> On 15. 10. 2012 Alan Ezust wrote:
>> > I was running a build of amarok from GIT from a month ago. I thought I'd
>> > rebuild the current trunk and try that.
>> > So I did a git pull yesterday and rebuilt everything.
>> >
>> > Now all the ratings I had set in the amarok database (external mysql)
>> > are
>> > gone.
>> >
>> > Any way to get them back?
>> > I see the "statistics" table still has 22000 rows in it,
>>
>> Then they are definitely not gone. Amarok deletes statistics for
>> unreachable
>> tracks on startup, so the tracks are there too. How many rows do you have
>> in
>> tracks table and how many tracks are physically in your collection?
>>
>
> 22000 approx. I should have been more precise in my previous message.
> I don't know if the ratings are "gone", I just know that I do not see stars
> stars for the ratings in the playlist view anymore.
>
>
>>
>> > but there is a new
>> > "statistics_permanent" table with only 315 rows.
>>
>> Unrelated and certainly not new.
>>
>

Note that using an external MySql and git versions is a recipe for
losing database content. If you want to keep testing git versions
(which we welcome very much) I suggest you switch back to mysqle and
make regular backups of the database, at least for every time you
update a git revision.
I've attached a script that I use to back-up mine before I run a
version with database changes.

["backup_userdata.sh" (application/x-sh)]

#!/bin/bash

cp -R $KDEHOME/share/apps/amarok $KDEHOME/share/apps/amarok.`date +%F`
cp $KDEHOME/share/config/amarokrc KDEHOME/share/config/amarokrc.`date +%F`
cp -R $KDEHOME/share/config/amarok_homerc $KDEHOME/share/config/amarok_homerc.`date +%F`
cp -R $KDEHOME/share/config/amarok-appletsrc $KDEHOME/share/config/amarok-appletsrc.`date +%F`


_______________________________________________
Amarok mailing list
Amarok@kde.org
https://mail.kde.org/mailman/listinfo/amarok


[prev in list] [next in list] [prev in thread] [next in thread]