<html>
  <head>
    <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
  </head>
  <body 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.<br>
    <br>
    <div class="moz-cite-prefix">On 03/04/17 21:05, daniel bip wrote:<br>
    </div>
    <blockquote
cite="mid:CANq0ti4SYROvUbFprQVkhtcJP3D787fajfVUXxfuNDnNgvCjUA@mail.gmail.com"
      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-mysql<br>
/var/cache/apt/archives/libqt5sql5-mysql_5.5.1+dfsg-16ubuntu7.2_amd64.deb<br>
            /var/lib/dpkg/info/libqt5sql5-mysql:amd64.list<br>
            /var/lib/dpkg/info/libqt5sql5-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/.local/share/digikam/db_misc/mysql.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/digikam/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 moz-do-not-send="true"
                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="HOEnZb">
                <div class="h5"><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>
  </body>
</html>