Bug 458704

Summary:	Migration Database
Product:	[Applications] digikam	Reporter:	foto19 <foto19>
Component:	Database-Migration	Assignee:	Digikam Developers <digikam-bugs-null>
Status:	RESOLVED WORKSFORME
Severity:	normal	CC:	metzpinguin
Priority:	NOR
Version First Reported In:	7.8.0
Target Milestone:	---
Platform:	Ubuntu
OS:	Linux
Latest Commit:		Version Fixed/Implemented In:	7.9.0
Sentry Crash Report:

Description foto19@ernst-buerjes.de 2022-09-04 17:52:13 UTC

I want to print fotobooks on my own printer and I want to use metadata (Caption, Notes, Keywords) to print them as titles etc. of the pictures. The tool to do this might be LibreOffice (LibreBase). LibreOffice can import a mySQL database, but no SQLite. 
So I tried to migrate the digiKam SQLite database to a mySQL database with the digiKam migration tool. But digiKam misses the file mysql_install_db and does not work. I installed the Ubuntu-Repository of Maria-db. The files mysqladmin and mysqld are present. But mysql_install_db is missing. What can I do?

Comment 1 Maik Qualmann 2022-09-04 18:04:05 UTC

Are you sure you have MariaDB installed? "mysql_install_db" is still included with MariaDB, but no longer with Oracle MySQL.

You plan to use an internal MySQL server, that's not easy, it has to be running before you can copy the SQLite database. I also think that LibreOffice expects a "proper" MySQL server. The digiKam internal MySQL server is started and stopped by digiKam and only communicates via a socket file. This will not work with LibreOffice. You need to set up an external MySQL server.

Maik

Comment 2 Maik Qualmann 2022-09-06 20:12:41 UTC

If mysql_install_db is not present in the MariaDB package on Ubuntu, open a bug report on Ubuntu. Data exchange with LibreOffice is a bit out of scope for us, I think everything is explained. If you have any questions, you are welcome to ask them. I'm closing the bug now.

Maik