database corruption -- how to fix?

[Mats Ahlgren]

So a quick recap:
My database got corrupted and I'm trying to recover my ratings, which  
I've spent whole days compiling.

After looking at the database more closely with
	> echo .dump | mysqlite3 [database] | less
It seems that apparently the database was recreated on top of the  
good one -- ratings are all at 0 and scores at 75, etc.

Is there any sort of automatic backup from which I can recover song  
ratings?

Thanks,
Mats

On Jan 22, 2007, at 12:18 PM, Mats Ahlgren wrote:

> On Jan 22, 2007, at 9:18 AM, Andrew Turner wrote:
>
>> Ok, well the basic approach is to try to work out if kded/hald are
>> working by running:
>> dcop kded mediamanager fullList
>>
>> That should give you a list of devices. Check the one with your
>> collection is listed.
>>
>> Next, using the SQLite binary (from www.sqlite.org),
>> SELECT id, lastmountpoint FROM devices;
>
> 1| /media/windows
> 2| /                                     <--- chose this one
> 3| /media/windows
> 4| /
>
>> Identify the one that should have your collection on. check how many
>> songs amarok thinks there are on that device (eg for id = 5):
>> SELECT count(url) FROM tags WHERE deviceid = 5;
>
> 3522
>
>> It's also worth looking in ~/.kde/share/config/amarokrc for the
>> [Collection Folders] section (note this is _not_ the now deprecated
>> Collection Folders field in the [Collection] section).
>> The format is something like:
>> 5=./music
>> where 5 refers to the device as above, and your collection folder has
>> an absolute path last given by: lastmountpoint_for_device5 + ./music
>
> 2=./home/mats/Music/Library
>
>> Note: deviceid = -1 means that for some reason Amarok couldn't figure
>> out which device your collection folder is on. The path is specified
>> relative to / .
>>
>> If there are weird dupes in that section of amarokrc, or the  
>> deviceids
>> are negative, but you are running kded/hald, or the deviceids are
>> positive but you aren't running kde/hald, problems may well happen.
>
> I have a process called kded running.
>
> What is all this telling me?
>
> Also, I tried overwriting my database.db file with an old backup;
> nothing happened (no statistics on any of the songs).
>
> I recently had file system corruption with ext3 (how on Earth? is
> this common...) and so a few random files got put in lost+found...
> maybe that is the culprit? If you think it is; how would I go about
> transferring the old DB (with everything such as ratings) to a new
> installation of Amarok on a fresh system?
>
> Thanks,
> Mats
>
>> Andrew
>>
>>
>> On 22/01/07, Mats Ahlgren <mats_a at mit.edu> wrote:
>>> No problem; thanks for replying.
>>>
>>> Unfortunately this is Amarok 1.4.3 and I'm not viewing my collection
>>> over NFS.
>>>
>>> Thanks,
>>> Mats
>>>
>>> On Jan 22, 2007, at 8:43 AM, Guðlaugur Jóhannesson wrote:
>>>
>>>> Sorry for coming in so late, but could it be that the new dynamic
>>>> collection
>>>> is giving you a hard time.  This could happen if you have recently
>>>> upgraded
>>>> amarok and mount your music collection over NFS or other removable
>>>> media.  To
>>>> turn it off set
>>>> DynamicCollection=false
>>>> in the [collection] section in amarokrc.
>>>>
>>>> --
>>>> Guðlaugur Jóhannesson
>>>> Tel: +354 849 8405
>>>> http://www.raunvis.hi.is/~gudlaugu/
>>>> _______________________________________________
>>>> Amarok mailing list
>>>> Amarok at kde.org
>>>> https://mail.kde.org/mailman/listinfo/amarok
>>>
>>>
>
> _______________________________________________
> Amarok mailing list
> Amarok at kde.org
> https://mail.kde.org/mailman/listinfo/amarok