Migrating from SQLite to MariaDB

[Maik Qualmann]

With the rebuild of the training data in the maintenance tool, you then have 
the current status of your confirmed faces in the core database. In addition, 
the matrices of the currently used face engine from digiKam. This training 
data maintenance should be done every now and then anyway to remove outdated 
entries or when we've changed the face engine. Manually copying the database 
is counterproductive.

Maik

Am Samstag, 25. März 2023, 15:47:40 CET schrieb 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