[Digikam-users] how to migrate to mysql

[Gilles Caulier]

We will review all works to do in database interface at next Coding
sprint planed in automn. The goal is to propose a project for next
GoSC 2015 to improve and stabilize MySQL/MariaDB support and perhaps
add Postgresql support.

I already triaged all reports about database. I have a clear vision of
the problems :

https://bugs.kde.org/buglist.cgi?bug_status=UNCONFIRMED&bug_status=CONFIRMED&bug_status=ASSIGNED&bug_status=REOPENED&component=database&list_id=1114379&product=digikam&query_format=advanced

In other words, use Sqlite in priority, and host database files to an
SSD. It run perfectly here to manage an huge collection (around 143000
items). Collection are hosted locally in Raid HDD and duplicated all
night to a NAS. I never use remote collections.

Gilles Caulier



2014-08-17 11:03 GMT+02:00 Robert Zeller <robert.zeller at robert-zeller.org>:
> On 08/16/2014 07:33 PM, upscope wrote:
>> On Saturday, August 16, 2014 11:37:54 AM Wybo wrote:
>>> I want to migrate my frequently crashing digikam sqlite database to my
>>> mysql database on my Synology station, but the migration tool says:
>>>
>>> Database connection test was not successful.
>>> Error was: Access denied for user 'wybo'@'wybo.fritz.box' (using
>>> password: YES) QMYSQL: Unable to connect
>>>
>>> My Synology station is on 192.168.178.27,
>>> the database listens to port 3306,
>>> on my FritzBox I forwarded port 3306 to 192.168.178.27,
>>> I can connect to the database on http://192.168.178.27/phpMyAdmin/
>>> I specified dk for the Schema name and dktn for the thumbnails Schema
>>> name, and whether or not I created those (empty) mysql databases makes
>>> no difference.
>>>
>>> What am I doing wrong?
>> I migrated a while back and if i remember right I had to:
>>       1. Create databases using phpMyAdmin (digikam4.db and thumbnails-
>> digikam.db
>>       2. Create a digikam user and give proper permissions.
>>       3. Go into digikam and select digikam settings -->database
>>               a. Create the necessary information (Hostname, Port, Schema
>>                  (digikam4.db), thumbnails (thumbnails-digikam.db, User Id
>>                  and password).
>>
>> Since version 4.0 came out I have not been able to access the database
>> and digikam eventually tells me the application is not responding.
>>
>> my digikam version is now: still fails. It does pass the connection
>> test, OK. If I drop back to version 3.5.0. everything was working with
>> mysql located on localhost.
>>
>> Don't know if this will help.
>>
>> Russ
> I had a similar problem with the mysql-Database since v. 4.1.0 came out.
> DK still was working but if I tried to change something in the settings,
> DK occupied one core completely and hung. After all I reinstalled DK
> from scratch using an sqlite database, which works fine. So I suppose
> something is wrong with the mysql schema in DK since 4.1.0
>
> _______________________________________________
> Digikam-users mailing list
> Digikam-users at kde.org
> https://mail.kde.org/mailman/listinfo/digikam-users