[Digikam-users] database troubles

[Christoph Siedentop]

On Tue, Jan 29, 2013 at 5:08 PM, Samuel Ronayette <sronayette at gmail.com> wrote:
> oh yes, I'm convinced I did something wrong, and there is no bug here... but
> almost each time I fiddle with the database, it goes wrong somehow...
> What is this "migration tool" I used in the first place? Why it didn't make
> a copy of my database?
This migration tool is not for you! It is for migrating your database
from sqlite to mysql.
> I understand that to make a backup of my database, I just copy the file
> digikam4.db somewhere else, is that right? (and is that enough to retrieve
> everything ?)
Yes, that is right.
> I never heard of this sidecar files, I'll have a look.
Normal JPEG images can save most Meta-information (like tags, caption,
title) inside the file. However,
some meta information can't be saved inside the jpeg file* and also
raw files like .NEF can't support all
meta information*. Therefore, the data is saved in a different file
that has the same name as your image but
with .xmp appended.

Have a look at saving the meta information inside the image file! (You
don't need the sidecar file for that but it won't hurt.)
This way, if you loose your database, then the data is also inside the file.

*: Not quite true, or at least I am not sure but good enough for the
explanation.

>
> Thank you for you answers.
>
> Samuel
>
> 2013/1/29 Anders Lund <anders at alweb.dk>
>>
>> Tirsdag den 29. januar 2013 16:05:43 skrev Volker Henn:
>>
>> > obviously it makes more fun programming face-recognition or other
>> > useless
>>
>> > things, instead of making the database stable. I also often lost tags
>> > etc.
>>
>>
>>
>> I rarely lost tags or other data, after using digikam since 2005 I believe
>> - and when I did, it was my fault, not digikam's.
>>
>>
>>
>> Since it became possible, I have digikam configured to add all data to the
>> image, either embedded or (for RAW files) in "sidecar" files.
>>
>>
>>
>> However, moving from pc to pc over the years have worked fine. I unpack a
>> backup of the digikam image directory on the new device, and add that to the
>> digikam collections. Job done.
>>
>>
>>
>> --
>>
>> Anders
>>
>>
>> _______________________________________________
>> Digikam-users mailing list
>> Digikam-users at kde.org
>> https://mail.kde.org/mailman/listinfo/digikam-users
>>
>
>
> _______________________________________________
> Digikam-users mailing list
> Digikam-users at kde.org
> https://mail.kde.org/mailman/listinfo/digikam-users
>



--
Christoph Siedentop
0176-399-422-45