[digiKam-users] MySQL internal

[digikam-2]

DK 5.9.0 appimage

Is there some instructions on how to migrate from sqlite to the
internal MySQL?

I have Mariadb 10.1.35-1 installed, including the client, but it
doesn't show up in the conversion tool:

https://i.imgur.com/sPYYgxP.png

--
sknahT

vyS

[Gilles Caulier-4]

Extend the dialog to the screen size. What do you see in Binary list view ?

Gilles Caulier

2018-09-01 21:10 GMT+02:00 <[hidden email]>:

DK 5.9.0 appimage

Is there some instructions on how to migrate from sqlite to the
internal MySQL?

I have Mariadb 10.1.35-1 installed, including the client, but it
doesn't show up in the conversion tool:

https://i.imgur.com/sPYYgxP.png

--
sknahT

vyS

[Maik Qualmann]

Again, you can not start or set up an internal MySQL server during migration.
You use SQlite, so you start digiKam, go into the settings of digiKam under
database and select internal MySQL server. In principle, you only have to
specify a directory where the MySQL database should be created. After OK, you
will be asked to add a collection, here simply enter an empty directory, so
that it is faster and you want to migrate the SQlite DB. Now you can migrate
your SQlite DB, then restart digiKam. A special feature is the AppImage, if
the mysqld is not found, you have to select it manually (/sbin/mysqld
eventually). Drag the window a bit larger, it's hidden. I hope you can do
something with this guide. Or should I create a screencast?

Maik

Am Samstag, 1. September 2018, 21:10:18 CEST schrieb [hidden email]:
> DK 5.9.0 appimage
>
> Is there some instructions on how to migrate from sqlite to the
> internal MySQL?
>
> I have Mariadb 10.1.35-1 installed, including the client, but it
> doesn't show up in the conversion tool:
>
> https://i.imgur.com/sPYYgxP.png

[digikam-2]

On Sat, 1 Sep 2018 21:41:17 +0200
Gilles Caulier <[hidden email]> wrote:

> Extend the dialog to the screen size. What do you see in Binary
> list view ?

Yes it shows up, but when I clicked on migrate I get:

https://i.imgur.com/gyyhQQj.png

--
sknahT

vyS

[digikam-2]

On Sat, 01 Sep 2018 21:46:22 +0200
Maik Qualmann <[hidden email]> wrote:

> Again, you can not start or set up an internal MySQL server during
> migration. You use SQlite, so you start digiKam, go into the
> settings of digiKam under database and select internal MySQL
> server. In principle, you only have to specify a directory where
> the MySQL database should be created. After OK, you will be asked
> to add a collection, here simply enter an empty directory, so that
> it is faster and you want to migrate the SQlite DB. Now you can
> migrate your SQlite DB, then restart digiKam. A special feature is
> the AppImage, if the mysqld is not found, you have to select it
> manually (/sbin/mysqld eventually). Drag the window a bit larger,
> it's hidden. I hope you can do something with this guide. Or should
> I create a screencast?

Screencast, please :)

--
sknahT

vyS

[Maik Qualmann]

Here is the link to the screencast. It takes a while for Google to encode the
video in all sizes and it's sharp. The demo only uses a very small SQlite
collection.

https://drive.google.com/file/d/1t6u1emc8_x8thZGsYZ64Ve3-kZ1ApFO7/view?
usp=sharing

Maik

Am Samstag, 1. September 2018, 22:21:39 CEST schrieb [hidden email]:

> On Sat, 01 Sep 2018 21:46:22 +0200
>
> Maik Qualmann <[hidden email]> wrote:
> > Again, you can not start or set up an internal MySQL server during
> > migration. You use SQlite, so you start digiKam, go into the
> > settings of digiKam under database and select internal MySQL
> > server. In principle, you only have to specify a directory where
> > the MySQL database should be created. After OK, you will be asked
> > to add a collection, here simply enter an empty directory, so that
> > it is faster and you want to migrate the SQlite DB. Now you can
> > migrate your SQlite DB, then restart digiKam. A special feature is
> > the AppImage, if the mysqld is not found, you have to select it
> > manually (/sbin/mysqld eventually). Drag the window a bit larger,
> > it's hidden. I hope you can do something with this guide. Or should
> > I create a screencast?
>
> Screencast, please :)

[digikam-2]

On Sat, 01 Sep 2018 23:07:55 +0200
Maik Qualmann <[hidden email]> wrote:

> Here is the link to the screencast. It takes a while for Google to
> encode the video in all sizes and it's sharp. The demo only uses a
> very small SQlite collection.
>
> https://drive.google.com/file/d/1t6u1emc8_x8thZGsYZ64Ve3-kZ1ApFO7/view?
> usp=sharing
>
> Maik

Thank you. I will be trying the conversion over the weekend.

I was missing the 1st step which is to create the database in the
config tools.

Thank you very much. Maybe the video should be posted somewhere on
digikam.kde

--
sknahT

vyS

[Maik Qualmann]

There is nothing missing in the screencast. You see the complete change from
SQlite to internal MySQL. The database is automatically created by digiKam if
it does not already exist. This happens at the point where you select internal
MySQL and exit the setup with OK. Again, to understand, internal MySQL has
nothing to do with a running local MySQL server. DigiKam creates the database
and a server instance itself and terminates it. The communication is via a
socket file.

Maik

Am Sonntag, 2. September 2018, 02:07:26 CEST schrieb [hidden email]:

> On Sat, 01 Sep 2018 23:07:55 +0200
>
> Maik Qualmann <[hidden email]> wrote:
> > Here is the link to the screencast. It takes a while for Google to
> > encode the video in all sizes and it's sharp. The demo only uses a
> > very small SQlite collection.
> >
> > https://drive.google.com/file/d/1t6u1emc8_x8thZGsYZ64Ve3-kZ1ApFO7/view?
> > usp=sharing
> >
> > Maik
>
> Thank you. I will be trying the conversion over the weekend.
>
> I was missing the 1st step which is to create the database in the
> config tools.
>
> Thank you very much. Maybe the video should be posted somewhere on
> digikam.kde