Migrating from SQLite to MariaDB

[Nick Seward]

Thanks Maik.

Will re-building the training data using the maintenance tool result in the same data that's in my SQLite DB? 
I'll see if I can manually copy this data over. I'd really like to keep my training data for facial recognition. 
I'll investigate manually copying this data over. Are there any technical hurdles or use cases I should consider before attempting this?

Nick


> Date: Sat, 25 Mar 2023 07:42:51 +0100
> From: Maik Qualmann <metzpinguin at gmail.com>
> To: digikam-users at kde.org
> Subject: Re: Migrating from SQLite to MariaDB
> Message-ID: <2672918.mvXUDI8C0e at linux-tpgn>
> Content-Type: text/plain; charset="iso-8859-1"
>
> 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 
> fingerprints.
>
> Maik
>
> 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