Moving from sqlite to mysql failure

[Simon Frei]

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.

On 03/04/17 21:41, daniel bip wrote:
> 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
> <mailto: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
>>     <mailto: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/.local/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
>>>         <mailto: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/7db78dda/attachment.html>