<html>
  <head>
    <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    Ok, so go to the location that you select on the right half of the
    database migration window. Then delete everything there (except of
    course if you have other data than the mysql database there). Then
    try again.<br>
    <br>
    <div class="moz-cite-prefix">On 03/04/17 21:41, daniel bip wrote:<br>
    </div>
    <blockquote
cite="mid:CANq0ti6c0WH8Oytt5Fy+p8udMqZNFNgXYT3xu0Zvy2ZkaOoaGg@mail.gmail.com"
      type="cite">
      <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 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">
            <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
                            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">
                          <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
                                            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="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>
    </blockquote>
    <br>
  </body>
</html>