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

List:       amarok
Subject:    Re: Restore Amarok MySQL dB
From:       "Seb Ruiz" <ruiz () kde ! org>
Date:       2008-09-23 22:11:40
Message-ID: 60ebdd0b0809231511s14f08384s9398319ba44fc928 () mail ! gmail ! com
[Download RAW message or body]

2008/9/24 Brian Blater <brb.lists@gmail.com>:
> On Mon, Sep 22, 2008 at 6:10 PM, Seb Ruiz <ruiz@kde.org> wrote:
>>
>> You'll have to do a bit of sql trickery unfortunately. Since you
>> reinstalled a new distro with most likely new partitions and what not,
>> the unique identifiers has changed. You'll need to find out your new
>> uuid (it will be listed in the devices table)
>>
>> SELECT * FROM devices;
>>
>> Find the correct device, and then update all your statistics with it:
>>
>> UPDATE statistics SET deviceid = correctid
>>
>>
>>
>> --
>> Seb Ruiz
>
> Thank you Seb.
>
> A couple of questions in regards to this. Looking at another machine
> right now, so not the db in question. From the devices table I need to
> find the mountpoint for the drive where the collection is stored and
> then see what ID it is assigned and use that as the 'correctid' in the
> UPDATE command above? Is that correct?

Correct.

-- 
Seb Ruiz

http://www.sebruiz.net/
http://amarok.kde.org/
_______________________________________________
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]