I'm trying to migrate my Digikam DB from SQLite to an external MySQL server (MariaDB 5.5.44 running on Qnap NAS). The process fails at 91% of "Copy ImageInformation" step with the error "Cannot add or update a child row: a foreign key constraint fails (`digikam`.`ImageInformation`, CONSTRAINT `ImageInformation_Images` FOREIGN KEY (`imageid`) REFERENCES `Images` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)"
Sorry, it seems that my SQLite database was corrupted in some way. I had to delete it and let Digikam rebuild a new DB, after that I successfully migrated to mySQL.
(In reply to Mattia from comment #0) > I'm trying to migrate my Digikam DB from SQLite to an external MySQL server > (MariaDB 5.5.44 running on Qnap NAS). > > The process fails at 91% of "Copy ImageInformation" step with the error > "Cannot add or update a child row: a foreign key constraint fails > (`digikam`.`ImageInformation`, CONSTRAINT `ImageInformation_Images` FOREIGN > KEY (`imageid`) REFERENCES `Images` (`id`) ON DELETE CASCADE ON UPDATE > CASCADE)" I got today same fail message with database migration tool sqlite -> mysql external server: 'Details: Cannot add or update a child row: a foreign key constraint fails (`mydk`.`ImageInformation`, CONSTRAINT `ImageInformation_Images` FOREIGN KEY (`imageid`) REFERENCES `Images` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)' Conditions: DK-5.7 Archlinux x86_64 Mariadb-10.1.28-1 DK works fine with sqlite.