<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class="">Thanks for your comments Giles.<div class=""><br class=""></div><div class="">Perhaps I don’t even need the MySQL database? </div><div class=""><br class=""></div><div class="">I’m trying to establish a shared database on my home server so that other users on other boxes will have the same access on their machines. Is there a “good” way of doing this other than relying on MYSQL? Or, should I simply dump all remnants of the existing dK installation (including configs etc) and reinstall using MySQL from the beginning?</div><div class=""><br class=""></div><div class="">Additional insight/direction is welcome and appreciated!</div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""></div><div class=""><br class=""><div><blockquote type="cite" class=""><div class="">On 04 Dec 2017, at 09:19, Gilles Caulier <<a href="mailto:caulier.gilles@gmail.com" class="">caulier.gilles@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class="">Hi,<div class=""><br class=""></div><div class="">A lots of work have be done to next 5.8.0 about Mysql support and migration tool. The current pre-release AppImage bundle can be tested here :</div><div class=""><br class=""></div><div class=""><a href="https://files.kde.org/digikam/" class="">https://files.kde.org/digikam/</a><br class=""></div><div class=""><br class=""></div><div class="">Gilles Caulier</div></div><div class="gmail_extra"><br class=""><div class="gmail_quote">2017-12-04 14:33 GMT+01:00 J Albrecht <span dir="ltr" class=""><<a href="mailto:heviiguy@gmail.com" target="_blank" class="">heviiguy@gmail.com</a>></span>:<br class=""><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I’ve tried to convert my database from SQLite to MySQL twice. Both attempts appeared to be going well until approximately 75% into the process. At those times, they failed with the following dialogue:<br class="">
<br class="">
Error while converting the database. Details: Cannot add or update a child row: a foreign key constraint fails (`digikam`.`ImageHaarMatrix`, CONSTRAINT `ImageHaarMatrix_Images` FOREIGN KEY (`imageid`) REFERENCES `Images` (`id`) ON DELETE CASCADE ON UPDATE CASCADE)<br class="">
<br class="">
Any idea how I might be able to overcome this critical issue?<br class="">
</blockquote></div><br class=""></div>
</div></blockquote></div><br class=""></div></body></html>