[Digikam-users] DigiKam with MySQL [solved]

[Johannes Kapune]

Hi Anders,

first I found in:
https://userbase.kde.org/Digikam/Tutorials
  - Advanced Features
      - Using digiKam with MySQL - how to migrate your data to MySQL so 
that you can use a server for your photos.

from 2013.

(https://userbase.kde.org/Digikam/Using_digiKam_with_MySQL)  from 2010


First release I used had included MySQL support, but at that time I did 
not use. Now I'm happy about not using because otherwise all my work in 
metadata had gone to waste by upgrading.



https://techbase.kde.org/Projects/Digikam/CodingSprint2014

yes, after some search I found this article where near at the end in 
"Task Details" they write:

"MySQL support is now disabled by default because it's not fully 
functional and still experimental. MySQL support is still fully 
available of course, but as an optional feature."


This makes my work on pictures now a little more difficult because it 
was planned to work from some different computer by different people on 
same collection of pictures (but not at same time), so server based data 
would help a lot. (Family use here)

Now we will try to write all metadata always into the pictures (exif or 
...?) but I'm sure there will come up some trouble.


I still hope that MySQL support will come back ASAP.
For me it would be also OK if I can save SQLite on same server where 
pictures are stored.


Johannes

Am 28.02.2015 um 08:22 schrieb Anders Stedtlund:
> Hi Johannes,
>
> Maybe you could ask on the opensuse-kde mailing list:
> http://lists.opensuse.org/opensuse-kde/
>
> /Anders
>
> 2015-02-27 14:47 GMT+01:00 Johannes Kapune <listen at kapune.de>:
>> Thanks for quick answer.
>>
>> I installed from:
>>
>>   http://download.opensuse.org/repositories/KDE:/Extra/openSUSE_13.1/
>>
>>
>> is there a repository where the mysql support is built in?
>>
>> Building myself is not what I want, and maybe not what I can do anyway
>> because lack of experience
>>
>>
>> Regards
>>
>> Johannes
>>
>> Am 27.02.2015 um 12:42 schrieb Philip Johnsson:
>>>
>>> DigiKam need to be built with mysql support which is a experimental
>>> feature due to lack of maintenance. If you can't select it maybe the
>>> Suse package maintainer haven't turned it on when they built it. If you
>>> really want it anyway you need to rebuild DigiKam with mysql support.
>>>
>>> Regards,
>>>
>>> Philip
>>>
>>> On Feb 27, 2015 11:55 AM, "Johannes Kapune" <listen at kapune.de
>>> <mailto:listen at kapune.de>> wrote:
>>>
>>>      Hello,
>>>
>>>      I'm using DigiKam 4.7.0 on a opensuse 13.1
>>>
>>>      first I use the SQLite as back end for storing metadata but now I
>>>      want to change to MySQL or MariaDB.
>>>
>>>      I started the database server but if I try to choose in DigiKam type
>>>      of database I only can choose SQLite.
>>>
>>>      Do I miss something? I have to prepare something before choosing
>>>      other database than SQLite?
>>>
>>>
>>>      How I can do further tests?
>>>
>>>
>>>      ps -A | grep my
>>>        5533 ?        00:00:00 mysqld_safe
>>>        5764 ?        00:00:01 mysqld
>>>      11764 ?        00:05:09 mysqld
>>>
>>>
>>>      Johannes
>>>      _________________________________________________
>>>      Digikam-users mailing list
>>>      Digikam-users at kde.org <mailto:Digikam-users at kde.org>
>>>      https://mail.kde.org/mailman/__listinfo/digikam-users
>>>      <https://mail.kde.org/mailman/listinfo/digikam-users>
>>>
>> _______________________________________________
>> Digikam-users mailing list
>> Digikam-users at kde.org
>> https://mail.kde.org/mailman/listinfo/digikam-users