Migrating from SQLite to MariaDB

[Gilles Caulier]

Hi all,

I just add a note in online documentation about the Core database
processed with migration tool:

https://docs.digikam.org/en/setup_application/database_settings.html#database-migration

Best regards

Gilles

Le sam. 25 mars 2023 à 16:17, Maik Qualmann <metzpinguin at gmail.com> a écrit :
>
> 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
>
>
>
>