Migrating to MySQL Internal fails

[Thomas Damgaard]

Hi,

How can I migrate digikam SQLite db to MySQL internal db? 

When trying to use the migrate function in settings, it says: "Error while opening the target database." 

In the terminal it says: 

digikam.dbengine: ConnectOptions "UNIX_SOCKET=/home/tdn/.local/share/digikam/db_misc/mysql.socket" --- digikam.dbengine: Error while opening the database. Error was QSqlError("2002", 

"QMYSQL: Unable to connect", "Can't connect to local MySQL server through socket '/home/tdn/.local/share/digikam/db_misc/mysql.socket' (2)")     

How do I fix this? Do I need a local MySQL server installed? 

I thought this was embedded in Digikam, right?

[Gilles Caulier-4]

2017-01-17 8:38 GMT+01:00 Thomas <[hidden email]>:

Hi,

How can I migrate digikam SQLite db to MySQL internal db? 

When trying to use the migrate function in settings, it says: "Error while opening the target database." 

In the terminal it says: 

digikam.dbengine: ConnectOptions "UNIX_SOCKET=/home/tdn/.local/share/digikam/db_misc/mysql.socket" --- digikam.dbengine: Error while opening the database. Error was QSqlError("2002", 

"QMYSQL: Unable to connect", "Can't connect to local MySQL server through socket '/home/tdn/.local/share/digikam/db_misc/mysql.socket' (2)")     

Which digiKam version do you use ?

 

How do I fix this? Do I need a local MySQL server installed? 

no need

 

I thought this was embedded in Digikam, right?

yes it is 

Gilles Caulier

[Thomas Damgaard]

2017-01-17 9:01 GMT+01:00 Gilles Caulier <[hidden email]>:

Which digiKam version do you use ?

Digikam version 5.4.0.

KDE frameworks: 5.29.0

Qt 5.7.0 (built against 5.7.0)

xcb windowing system

This is what I do:

Open digikam with my current collection that is using sqlite.

Then open Settings > Database Migration 

Then I do not change anything on left side.

On right side, I change type from SQLIte to MySQL Internal.

I then set the path where I want to store db. (actually I leave it unchanced as ~/Pictures)

Then I look in the box named MySQL binaries. It lists two binaries: mysql_install_db and mysqld. Both have a checkmark on the left.

There is an option to "Change or download". I do not touch these.

Then I click "Migrate ->"

And I get the error:

Error while opening the target database.

I have plenty of free space.

There are no permission problems on the folder, etc.

[AndriusWild]

Hello

I actually downloaded and installed MariaDB when I was migrating my database.

Everything went smooth.

I actually did not know that I did not have to do so since digikam has that functionality embedded.

On Tue, Jan 17, 2017 at 5:00 AM, Thomas <[hidden email]> wrote:

2017-01-17 9:01 GMT+01:00 Gilles Caulier <[hidden email]>:

Which digiKam version do you use ?

Digikam version 5.4.0.

KDE frameworks: 5.29.0

Qt 5.7.0 (built against 5.7.0)

xcb windowing system

This is what I do:

Open digikam with my current collection that is using sqlite.

Then open Settings > Database Migration 

Then I do not change anything on left side.

On right side, I change type from SQLIte to MySQL Internal.

I then set the path where I want to store db. (actually I leave it unchanced as ~/Pictures)

Then I look in the box named MySQL binaries. It lists two binaries: mysql_install_db and mysqld. Both have a checkmark on the left.

There is an option to "Change or download". I do not touch these.

Then I click "Migrate ->"

And I get the error:

Error while opening the target database.

I have plenty of free space.

There are no permission problems on the folder, etc.

[Thomas Damgaard]

2017-01-17 13:26 GMT+01:00 Andrey Goreev <[hidden email]>:

I actually downloaded and installed MariaDB when I was migrating my database.

Everything went smooth.

I actually did not know that I did not have to do so since digikam has that functionality embedded.

Can you check if the MariaDB server that you installed is actually used? 

[Thomas Damgaard]

2017-01-17 13:00 GMT+01:00 Thomas <[hidden email]>:

Digikam version 5.4.0.

KDE frameworks: 5.29.0

Qt 5.7.0 (built against 5.7.0)

xcb windowing system

I want to add that OS is Debian 8, 64 bit.

And that digikam is from the most recent AppImage bundle downloaded from the digikam website.