[Digikam-users] upgrade / import captions from old digikam-db

[Gerrit Holl]

[Gys van Zyl]
> Install SQLite database browser from the ubuntu software center
> Open the new computer's digikam database file in SQLite browser
> Go to the "browse data" tab
> In the albumroots table, find the volumeid of your new collection, copy and paste it into a text editor
> Copy the old computer's database file to the new computer.
> Open this file in SQLite browser
> Change the volumeid to the one recorded before, save and exit

Unfortunately, my old digikam3.db does not have an albumroots table
and I cannot find where to change the volumeid

On 20 May 2010 10:45, Marcel Wiesweg <marcel.wiesweg at gmx.de> wrote:
> Copy the database file and the digikamrc file (~/.kde4/share/config/) to your
> new system. I'd by interested if all works smoothly. You should be asked about
> a changed partition, with a suggestion to the new place.
> It should work, if not there's a bug somewhere.

I have tried this, but the new captions do not show up. However, they
are in the database!

For example, imageid=43935, in table ImageComments, has
comment="Rautasälven in autumn". In the 'Images' table, the field for
'album' is empty. It seems my database is messed up now... If you want
I can upload this digikam4_messedup.db somewhere. I'll try some more.

Gerrit.