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

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

tricky

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

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.

Resolved

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