TechSpot

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.
    Request
    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.

    Thanks
  2. steeve

    steeve Newcomer, in training Posts: 192

    tricky

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

    Zilpha TechSpot Enthusiast Posts: 349

    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 Newcomer, in training Topic Starter

    Resolved

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


Add New Comment

TechSpot Members
Login or sign up for free,
it takes about 30 seconds.
You may also...


Get complete access to the TechSpot community. Join thousands of technology enthusiasts that contribute and share knowledge in our forum. Get a private inbox, upload your own photo gallery and more.