Migrating from SQLite to MariaDB

Maik Qualmann metzpinguin at gmail.com
Sat Mar 25 06:42:51 GMT 2023

Yes, only the digiKam core database will be migrated. All other databases are 
rebuilt, the thumbnail database during use or by the maintenance tool. The 
face database with the maintenance tool and the option to rebuild the training 
data, the similarity database also via the maintenance tool and rebuild the 


Am Samstag, 25. März 2023, 01:38:43 CET schrieb Nick Seward:
> Hi All,
> After a year of using SQLite as the DB for Digikam I'd like switch to a
> dedicated MariaDB instance as my database backend. I went through the
> DigiKam DB docs
> (https://docs.digikam.org/en/setup_application/database_settings.html#),
> setup a MariaDB instance and then used the Database Migration tool to move
> my data to the new DB. When I did this, only the core Digikam SQLite db was
> migrated. The "thumbs", "faces" and "similarity" SQLite db's weren't
> migrated. Is that expected?
> I'm using DigiKam 7.10.0 on an Intel MacBook Pro running MacOS 13.2.1.
> I'm running MariaDB 10.11 on a computer on my local network using Docker.
> Thanks,
> Nick

More information about the Digikam-users mailing list