<div dir="ltr"><div><div><div>Hi Simon,<br><br></div>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...<br><br></div>Thx.<br><br></div>BR,<br> <br></div><div class="gmail_extra"><br><div class="gmail_quote">On 3 April 2017 at 21:36, Simon Frei <span dir="ltr"><<a href="mailto:freisim93@gmail.com" target="_blank">freisim93@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
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?<div><div class="h5"><br>
<br>
<div class="m_4005523021130352123moz-cite-prefix">On 03/04/17 21:33, daniel bip wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div>
<div>
<div>
<div>Hi Simon,<br>
<br>
</div>
I'm not sure I really get it, may you explain that in a
different way?<br>
<br>
</div>
Thanks for you support.<br>
<br>
</div>
BR,<br>
<br>
<br>
</div>
d.<br>
<br>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On 3 April 2017 at 21:18, Simon Frei <span dir="ltr"><<a href="mailto:freisim93@gmail.com" target="_blank">freisim93@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"> Cool, I remembered
the first issue correctly :)<br>
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.
<div>
<div class="m_4005523021130352123h5"><br>
<br>
<div class="m_4005523021130352123m_4533405178786748195moz-cite-prefix">On
03/04/17 21:05, daniel bip wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">
<div>
<div>
<div>
<div>Hi Simon,<br>
<br>
</div>
I installed DK from Philip Johnsson's PPA.<br>
<br>
</div>
If I try lo locate libqt5sql5-mysql I get
this:<br>
<br>
/usr/share/doc/libqt5sql5-mysq<wbr>l<br>
/var/cache/apt/archives/libqt5<wbr>sql5-mysql_5.5.1+dfsg-16ubuntu<wbr>7.2_amd64.deb<br>
/var/lib/dpkg/info/libqt5sql5-<wbr>mysql:amd64.list<br>
/var/lib/dpkg/info/libqt5sql5-<wbr>mysql:amd64.md5sums<br>
<br>
</div>
So, I tried apt-get install libqt5sql5-mysql and
it did install something but it continues to
crash, in a different way:<br>
<br>
digikam.general: scan mode: ScanDeferredFiles<br>
digikam.general: Testing "mysql_install_db" ...<br>
digikam.general: Found "mysql_install_db"<br>
digikam.general: Testing "mysqld" ...<br>
digikam.general: Found "mysqld"<br>
digikam.general: Testing "mysql_install_db" ...<br>
digikam.general: Found "mysql_install_db"<br>
digikam.general: Testing "mysqld" ...<br>
digikam.general: Found "mysqld"<br>
digikam.dbengine: ConnectOptions
"UNIX_SOCKET=/home/daniel/.loc<wbr>al/share/digikam/db_misc/mysql<wbr>.socket"<br>
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/dig<wbr>ikam/db_misc/mysql.socket'
(2)")<br>
digikam.general: total scan value : 97076<br>
<br>
</div>
<br>
<div class="gmail_extra">Thanks for helping!<br>
<br>
</div>
<div class="gmail_extra">BR,<br>
<br>
</div>
<div class="gmail_extra"><br>
</div>
<div class="gmail_extra">d.<br>
<br>
<br>
</div>
<div class="gmail_extra">
<div class="gmail_quote">On 3 April 2017 at
20:43, Simon Frei <span dir="ltr"><<a href="mailto:freisim93@gmail.com" target="_blank">freisim93@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi,<br>
<br>
Do you have the libqt5sql5-mysql package
installed?<br>
Or more generally, where do you install
digiKam from?<br>
<br>
Cheers,<br>
Simon<br>
<div class="m_4005523021130352123m_4533405178786748195HOEnZb">
<div class="m_4005523021130352123m_4533405178786748195h5"><br>
<br>
On 03/04/17 19:11, daniel bip wrote:<br>
> Hi there,<br>
><br>
> May someone assist me in moving
from sqlite to mysql internal?<br>
><br>
> I'm running Ubuntu 16.04 LTS and DK
5.5.0. I also installed<br>
> mysql-server-5.7. I did nothing
else (mysql is not setup in any way, I<br>
> mean).<br>
><br>
> In the migration windows
mysql_install_db is shown as a green
tick,<br>
> and also is mysqld. But when I
click on Migrate I get a pop up warning<br>
> stating "Error while opening the
target database" and command line says<br>
><br>
> "digikam.dbengine: Error while
opening the database. Error was<br>
> QSqlError("", "Driver not loaded",
"Driver not loaded")"<br>
><br>
> mysql is up and running so I guess
I am just missing something<br>
> important, may someone give me a
clue?<br>
><br>
> Thx.<br>
><br>
> BR,<br>
><br>
><br>
> d.<br>
<br>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</div>
</blockquote>
<br>
</div>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</blockquote>
<br>
</div></div></div>
</blockquote></div><br></div>