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

G

glass4u

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
 
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.
 
You must log in or register to reply here.

Latest posts

Back