Update, clean, and move database?

classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

Update, clean, and move database?

Jasper
I am upgrading from dear old Debian to Ubuntu (gfx issues) and want to move the Digikam database and digikam settings over to the new install...
 This is a very old db starting way way back in the day of sqlight3 moved to mysql etc... this was well before face recognition.

Face recognition has worked to some extent on a clean install/db but never with my db.

Can anyone help me please clean up the db and get face recognition etc going.

Could it be that I already have tags People/blah,blah...?

Any tips for super safe moving of db and mysql on ubuntu.

Cheers.

Jasper
Reply | Threaded
Open this post in threaded view
|

Re: Update, clean, and move database?

maderios
On 01/07/2014 01:49 AM, Jasper wrote:
> I am upgrading from dear old Debian to Ubuntu (gfx issues) and want to move
> the Digikam database and digikam settings over to the new install.

Hi
Why migrating from Debian to Ubuntu ?  Debian is much more stable than
Ubuntu.
--
Maderios


_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users
Reply | Threaded
Open this post in threaded view
|

Re: Update, clean, and move database?

Peter Albrecht
In reply to this post by Jasper
Hi Jasper,

I try to use the digiKam db only as a fast cache for image
meta information.
-> I configured digikam to store all important info (for me:
Tags, Comments, Rating) in the JPG's metadata (EXIF/XMP).

At my last migration from 32 Bit to 64 Bit, I started with a
fresh digikam installation and copied only the jpg files to
the new installation.
Digikam db and thumbnail db were recreated well.

I did not copy digikam settings, but went through all of
them again. Once in a while, new interesting settings are
added, which I wouldn't have found otherwise.

This worked well for me. Maybe other people with other
settings/conditions might have problems with this way.

Regards,
        Peter

On 07.01.2014 01:49, Jasper wrote:

> I am upgrading from dear old Debian to Ubuntu (gfx issues) and want to move
> the Digikam database and digikam settings over to the new install...
>
> ...
>
> Any tips for super safe moving of db and mysql on ubuntu.
>
> Cheers.
>
> Jasper
>
>
>
> --
> View this message in context: http://digikam.1695700.n4.nabble.com/Update-clean-and-move-database-tp4667797.html
> Sent from the digikam-users mailing list archive at Nabble.com.
> _______________________________________________
> Digikam-users mailing list
> [hidden email]
> https://mail.kde.org/mailman/listinfo/digikam-users
>
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users
Reply | Threaded
Open this post in threaded view
|

Re: Update, clean, and move database?

Jasper
hmm, intersting.
 I am worried due to the sheer size of the photo collection that I will not be able to find the problem photos where the metadata didnt stick.

How can I be sure that _all_ and I mean _all!_ metadata is saved to exif/xmp. What will I lose?

It will be a giant pain to rebuild the tag tree again tho OMG!!.

BUT if this works, I like it. It is robust for sure!

Cheers
Reply | Threaded
Open this post in threaded view
|

Re: Update, clean, and move database?

Peter Albrecht
Hi Jasper,

On 18.01.2014 02:00, Jasper wrote:
> I am worried due to the sheer size of the photo collection that I will not
> be able to find the problem photos where the metadata didnt stick.
>
> How can I be sure that _all_ and I mean _all!_ metadata is saved to
> exif/xmp. What will I lose?

I guess, there is no chance to be 100% sure, apart from
looking at every image by hand. But you won't want to do
that. ;)

Best thing, I could come up with:

a) MAKE A BACKUP!!!! ;)
  Of your images and your digikam database.


b) Test, whether your digikam installation in general is
writing all the metadata, you want: Edit one Image and add
tags, a comment, rating, ...

Than go to console and call
  exiv2 -p a my_image.jpg
to verify, all data has been written to the jpg.

Allmost all of the important data will be found in the
XMP-Section. E.g.:
  - Xmp.xmp.Rating
  - Xmp.digiKam.TagsList
  - ...

If you can find all of your important data in this dump,
digiKam should be able to read this again.


c) Do a search which brings up all your images. ;)
Select all of them and choose from the menu:
  "Image" -> "Write Metadata to Image"
This should write all the types of metadata (checked in b)
to your image files. And brings all metadata-sections in the
file to the same version.

If the amount of your images is too large, you could do this
e.g. per year. Goal is, to call "Write Metadata to Image"
for every single image at least once.


d) Now, you can move away your old digiKam database, start a
new one and import your metadata from the image files again.


That's the way, I would go.

Regards,
        Peter Albrecht
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users
Reply | Threaded
Open this post in threaded view
|

Re: Update, clean, and move database?

Jasper
Thank you very much Peter,
 I will try it and let the list know how it goes.
Its a good excuse to back up all the images a few times eh 8)

Jasper