Moving from sqlite to mysql failure

[daniel bip]

Hi Simon,

I'm trying to migrate from sqlite to mysql internal. What I do is just open
Settings > Database migration, setup the right half of the screen
accordingly and then press on Migrate. And then the error pops up...

Thx.

BR,


On 3 April 2017 at 21:36, Simon Frei <freisim93 at gmail.com> wrote:

> Sorry, but in that case I need more information first: What do you want to
> do and what exactly are the steps you perform, before you get that error?
>
>
> On 03/04/17 21:33, daniel bip wrote:
>
> Hi Simon,
>
> I'm not sure I really get it, may you explain that in a different way?
>
> Thanks for you support.
>
> BR,
>
>
> d.
>
>
> On 3 April 2017 at 21:18, Simon Frei <freisim93 at gmail.com> wrote:
>
>> Cool, I remembered the first issue correctly :)
>> The error you get now I do seldomly get as well, when I manage to damage
>> the database (outside of digikam). So as you said you are migrating, I
>> would suggest removing everything related to the new mysql database and
>> start a new clean migration from sqlite.
>>
>>
>> On 03/04/17 21:05, daniel bip wrote:
>>
>> Hi Simon,
>>
>> I installed DK from Philip Johnsson's PPA.
>>
>> If I try lo locate libqt5sql5-mysql I get this:
>>
>> /usr/share/doc/libqt5sql5-mysql
>> /var/cache/apt/archives/libqt5sql5-mysql_5.5.1+dfsg-16ubuntu7.2_amd64.deb
>> /var/lib/dpkg/info/libqt5sql5-mysql:amd64.list
>> /var/lib/dpkg/info/libqt5sql5-mysql:amd64.md5sums
>>
>> So, I tried apt-get install libqt5sql5-mysql and it did install something
>> but it continues to crash, in a different way:
>>
>> digikam.general: scan mode: ScanDeferredFiles
>> digikam.general: Testing  "mysql_install_db" ...
>> digikam.general: Found  "mysql_install_db"
>> digikam.general: Testing  "mysqld" ...
>> digikam.general: Found  "mysqld"
>> digikam.general: Testing  "mysql_install_db" ...
>> digikam.general: Found  "mysql_install_db"
>> digikam.general: Testing  "mysqld" ...
>> digikam.general: Found  "mysqld"
>> digikam.dbengine: ConnectOptions  "UNIX_SOCKET=/home/daniel/.loc
>> al/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/daniel/.local/share/digikam/db_misc/mysql.socket'
>> (2)")
>> digikam.general: total scan value :  97076
>>
>>
>> Thanks for helping!
>>
>> BR,
>>
>>
>> d.
>>
>>
>> On 3 April 2017 at 20:43, Simon Frei <freisim93 at gmail.com> wrote:
>>
>>> Hi,
>>>
>>> Do you have the libqt5sql5-mysql package installed?
>>> Or more generally, where do you install digiKam from?
>>>
>>> Cheers,
>>> Simon
>>>
>>>
>>> On 03/04/17 19:11, daniel bip wrote:
>>> > Hi there,
>>> >
>>> > May someone assist me in moving from sqlite to mysql internal?
>>> >
>>> > I'm running Ubuntu 16.04 LTS and DK 5.5.0. I also installed
>>> > mysql-server-5.7. I did nothing else (mysql is not setup in any way, I
>>> > mean).
>>> >
>>> > In the migration windows mysql_install_db is shown as a green tick,
>>> > and also is mysqld. But when I click on Migrate I get a pop up warning
>>> > stating "Error while opening the target database" and command line says
>>> >
>>> > "digikam.dbengine: Error while opening the database. Error was
>>> > QSqlError("", "Driver not loaded", "Driver not loaded")"
>>> >
>>> > mysql is up and running so I guess I am just missing something
>>> > important, may someone give me a clue?
>>> >
>>> > Thx.
>>> >
>>> > BR,
>>> >
>>> >
>>> > d.
>>>
>>>
>>
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20170403/09bb9e1b/attachment.html>