<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body style="overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;"><div>Hi Mike,</div><div>Thanks for asking.</div>I thought mysql internal was better for large collection of photos on hard disks, as recommended by the documentation. <div>In the old days, I did use sqlit, but as my collection gets larger, it slowed down quite a bit. Once I converted to mysql internal, it worked much faster.</div><div>If in the future I can put my collection on SSD, sqlit might be better. My question then is how to convert back from mysql to sqlit.</div><div>Fred<br id="lineBreakAtBeginningOfMessage"><div><br><blockquote type="cite"><div>On Mar 16, 2025, at 20:55, Michael Miller <michael_miller@msn.com> wrote:</div><br class="Apple-interchange-newline"><div>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<div style="overflow-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;">
Hi Fred,
<div>I know this isn’t a “fix”, but what is the reason for using MySql/MariaDB instead of SQLite?</div>
<div><br>
</div>
<div>I used to think that MariaDB was somehow better, but after extensive testing and joining the dev team, I found out that SQLite is faster and mode stable than MySql/MariaDB for digiKam. The only reasons to use MySql/MariaDB is if you are running the DB
on a remote server for a multi-computer installation. </div>
<div><br>
</div>
<div>It sounds like you’re using a MariaDB install on the same computer as digiKam, correct?</div>
<div><br>
</div>
<div>Cheers,</div>
<div>Mike<br id="lineBreakAtBeginningOfMessage">
<div><br>
<blockquote type="cite">
<div>On Mar 15, 2025, at 11:16 PM, Fred Engst <fredengst@gmail.com> wrote:</div>
<br class="Apple-interchange-newline">
<div>
<div>
<div class="BodyFragment"><font size="2"><span style="font-size:11pt;">
<div class="PlainText">Hi Gilles or Maik,<br>
It seems that digikam is not compatible with mariadb version 11.7.2 for mysql internal.
<br>
<br>
On my MacBook pro, I had mariadb 11.2.1 before, and it worked fine with digikam 8.5.<br>
<br>
But when I tried to run digikam on my new Mac Mini M4 Pro with the only mariadb version 11.7.2 that I was able to install, it gives me an error message: "Could not start database initializer.”<br>
<br>
I also donwloaded the latest <br>
"digiKam-8.7.0-20250315T120428-Qt6-MacOS-arm64”, or <br>
"digiKam-8.6.0-Qt6-MacOS-arm64”, <br>
on the Mac Mini, and it gives the same error message.<br>
<br>
I then upgraded mariadb on my MacBook Pro to 11.7.2 by mistake, and now I can’t make digikam work on my MacBook Pro with mysql internal running digikam 8.5 or 8.6! The same error message as in Mac Mini.<br>
<br>
<br>
The error log from my Macbook Pro running digikam 8.6 is attached:<br>
</div>
</span></font></div>
<div class="BodyFragment"><font size="2"><span style="font-size:11pt;">
<div class="PlainText"><br>
Fred<br>
<br>
> On Mar 9, 2025, at 15:15, Maik Qualmann <metzpinguin@gmail.com> wrote:<br>
> <br>
> Please create a debug log from the start in the terminal, as described here <br>
> for macOS:<br>
> <br>
> <a href="https://www.digikam.org/contribute/#macos-host" originalsrc="https://www.digikam.org/contribute/#macos-host">
https://www.digikam.org/contribute/#macos-host</a><br>
> <br>
> Maik<br>
> <br>
> Am Sonntag, 9. März 2025, 06:23:22 Mitteleuropäische Normalzeit schrieb Fred <br>
> Engst:<br>
>> Dear digikam team,<br>
>> I have just purchased a Mac Mini M4 Pro and download all file that are<br>
>> needed for digikam, but I’m not able to start it.<br>
>> <br>
>> Here is the error I get using digitkam 8.5.0 at startup:<br>
>> ————————————————————————————————————<br>
>> An error occurred during the internal server start.<br>
>> Details: Could not start database initializer.<br>
>> Executable: /Applications/digiKam.org/digikam.app/Contents/lib/mariadb/<br>
>> <<a href="http://digikam.app/Contents/lib/mariadb/" originalsrc="http://digikam.app/Contents/lib/mariadb/">http://digikam.app/Contents/lib/mariadb/</a>> bin/mariadb-install-db<br>
>> Arguments: --defaults-file=/Applications/digiKam.org/digikam.app/<br>
>> <<a href="http://digikam.app/" originalsrc="http://digikam.app/">http://digikam.app/</a>>Contents/Resources/digikam/database/mysql-global.conf,<br>
>> --basedir=/ Applications/digiKam.org/digikam.app/Contents//lib/mariadb/<br>
>> <<a href="http://digikam.app/Contents//lib/mariadb/" originalsrc="http://digikam.app/Contents//lib/mariadb/">http://digikam.app/Contents//lib/mariadb/</a>>,<br>
>> --datadir=/Users/chief/Pictures/.mysql.digikam/db_data Process error:<br>
>> Unknown error<br>
>> Please check the database settings in this dialog.<br>
>> ————————————————————————————————————<br>
>> <br>
>> I then successively installing mariadb 11.7.2 with my admin account (chief),<br>
>> and here is the log:<br>
>> ---------------------------------------------------------------------------<br>
>> -------------------- Welcome to the MariaDB monitor. Commands end with ; or<br>
>> \g.<br>
>> Your MariaDB connection id is 75<br>
>> Server version: 11.7.2-MariaDB Homebrew<br>
>> <br>
>> Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.<br>
>> <br>
>> Type 'help;' or '\h' for help. Type '\c' to clear the current input<br>
>> statement.<br>
>> <br>
>> MariaDB [(none)]> quit<br>
>> Bye<br>
>> chief@192 ~ % MySQL.server start<br>
>> Starting MariaDB<br>
>> /opt/homebrew/Cellar/mariadb/11.7.2/bin/mysqld_safe: Deprecated program<br>
>> name. It will be removed in a future release, use 'mariadbd-safe' instead<br>
>> 250308 08:34:43 mysqld_safe Logging to<br>
>> '/opt/homebrew/var/mysql/192.168.0.109.err'. SUCCESS! chief@192 ~ % 250308<br>
>> 08:34:43 mysqld_safe Starting mariadbd daemon with databases from<br>
>> /opt/homebrew/var/mysql chief@192 ~ %<br>
>> ————————————————————————————————————<br>
>> <br>
>> <br>
>> I then downloaded digikam 8.6.0, and here is the error I get:<br>
>> ————————————————————————————————————<br>
>> An error occurred during the internal server start.<br>
>> Details: Could not start database initializer.<br>
>> Executable: /opt/homebrew/Cellar/mariadb/11.7.2/scripts/mariadb-install-db<br>
>> Arguments: --defaults-file=/Applications/digiKam-8.6.org/<br>
>> <<a href="http://digikam-8.6.org/" originalsrc="http://digikam-8.6.org/">http://digikam-8.6.org/</a>>digikam.app/Contents/Resources/digikam/database/my<br>
>> sql-global.conf<br>
>> <<a href="http://digikam.app/Contents/Resources/digikam/database/mysql-global.conf" originalsrc="http://digikam.app/Contents/Resources/digikam/database/mysql-global.conf">http://digikam.app/Contents/Resources/digikam/database/mysql-global.conf</a>>,<br>
>> --basedir= Applications/digiKam.org/digikam.app/<http://digikam.app/><br>
>> Contents//lib/mariadb/, --datadir=/Users/chief/<br>
>> Pictures/.mysql.digikam/db_data<br>
>> Process error: Unknown error<br>
>> ————————————————————————————————————<br>
<br>
<br>
</div>
</span></font></div>
</div>
<span id="cid:E641F18DB889474E8455ABAEABE8EE34@NAMP222.PROD.OUTLOOK.COM"><FredEngst'sMacbookPro_digikam8.6-ErrorLog.txt></span></div>
</blockquote>
</div>
<br>
</div>
</div>
</div></blockquote></div><br></div></body></html>