just lost all my ratings after running the latest git of amarko

[Bart Cerneels]

On Tue, Oct 16, 2012 at 1:32 AM, Alan Ezust <alan.ezust at gmail.com> wrote:
>
>
> On Mon, Oct 15, 2012 at 12:32 PM, Matěj Laitl <matej at 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.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: backup_userdata.sh
Type: application/x-sh
Size: 343 bytes
Desc: not available
URL: <http://mail.kde.org/pipermail/amarok/attachments/20121016/97b23772/attachment.sh>