What's the easiest way to modify an sql (digikam) database (sql newbie)

By glass4u
Sep 8, 2011
Post New Reply
  1. OS = Linux; Distro = Fedora 15
    Digikam = Version 1.9.0
    Using KDE Development Platform 4.6.5 (4.6.5)
    background and problem
    Following a disk crash I installed a new disk and copied in the Digikam database (and photos) from backup.
    Digikam correctly identifies the photos but has lost the tag to photo links because the sql database points at the UUID of the crashed disk and the former path to the photos. To change this I need to edit the database.
    I need guiding on the easiest software / way to edit the database (GUI interface would be good).
    p.s. I know nothing about SQL editing.

  2. steeve

    steeve TS Enthusiast Posts: 146


    maybe you could get help on the digikam mailing list....
  3. Zilpha

    Zilpha TS Enthusiast Posts: 319

    If you are just looking for an easy way to edit tables, try Navicat lite. It's pretty straightforward to get connected to a database and all the tables are in a nice graphical format. There are downloads for Linux as well as Windows.

    If you are looking for what table specifically to edit - well I can't help you there.
  4. glass4u

    glass4u TS Rookie Topic Starter


    many thanks for that. I know the table to change.
    All is now sorted.

Similar Topics

Add New Comment

You need to be a member to leave a comment. Join thousands of tech enthusiasts and participate.
TechSpot Account You may also...