[Digikam-users] how to migrate to mysql

[David Lindblad]

TIA Gilles!
This is most welcome as my db is growing and is becoming increasingly slow on 
sqlite. Why not have MySQL as default db if available at installation of dk? 
I use SSD disk, Intel i7 cpu and 32GBRAM. 
A copy of my db statistic might give a hint of why I would like better support 
for mysql :
Digikam version 4.2.0
Bilder: 
BMP: 95
GIF: 74
JP2: 10
JPEG: 1
JPG: 818349
PNG: 68
PPM: 12
RAW-ARW: 2087
RAW-CR2: 183111
RAW-DNG: 304
RAW-HDR: 1
RAW-NEF: 327
TIFF: 2587
XCF: 114
totalt: 1007140
: 
: 
Videor: 
3GP: 133
AVI: 746
MOV: 403
MP4: 20
totalt: 1302
: 
: 
Totalt antal objekt: 1008442
Album: 20619
Etiketter: 548
Databasgränssnitt: QSQLITE


/David


 söndagen den 17 augusti 2014 12.01.12 skrev  Gilles Caulier:
> We will review all works to do in database interface at next Coding
> sprint planed in automn. The goal is to propose a project for next
> GoSC 2015 to improve and stabilize MySQL/MariaDB support and perhaps
> add Postgresql support.
> 
> I already triaged all reports about database. I have a clear vision of
> the problems :
> 
> https://bugs.kde.org/buglist.cgi?bug_status=UNCONFIRMED&bug_status=CONFIRMED
> &bug_status=ASSIGNED&bug_status=REOPENED&component=database&list_id=1114379&
> product=digikam&query_format=advanced
> 
> In other words, use Sqlite in priority, and host database files to an
> SSD. It run perfectly here to manage an huge collection (around 143000
> items). Collection are hosted locally in Raid HDD and duplicated all
> night to a NAS. I never use remote collections.
> 
> Gilles Caulier
> 
> 2014-08-17 11:03 GMT+02:00 Robert Zeller <robert.zeller at robert-zeller.org>:
> > On 08/16/2014 07:33 PM, upscope wrote:
> >> On Saturday, August 16, 2014 11:37:54 AM Wybo wrote:
> >>> I want to migrate my frequently crashing digikam sqlite database to my
> >>> mysql database on my Synology station, but the migration tool says:
> >>> 
> >>> Database connection test was not successful.
> >>> Error was: Access denied for user 'wybo'@'wybo.fritz.box' (using
> >>> password: YES) QMYSQL: Unable to connect
> >>> 
> >>> My Synology station is on 192.168.178.27,
> >>> the database listens to port 3306,
> >>> on my FritzBox I forwarded port 3306 to 192.168.178.27,
> >>> I can connect to the database on http://192.168.178.27/phpMyAdmin/
> >>> I specified dk for the Schema name and dktn for the thumbnails Schema
> >>> name, and whether or not I created those (empty) mysql databases makes
> >>> no difference.
> >>> 
> >>> What am I doing wrong?
> >> 
> >> I migrated a while back and if i remember right I had to:
> >>       1. Create databases using phpMyAdmin (digikam4.db and thumbnails-
> >> 
> >> digikam.db
> >> 
> >>       2. Create a digikam user and give proper permissions.
> >>       3. Go into digikam and select digikam settings -->database
> >>       
> >>               a. Create the necessary information (Hostname, Port, Schema
> >>               
> >>                  (digikam4.db), thumbnails (thumbnails-digikam.db, User
> >>                  Id
> >>                  and password).
> >> 
> >> Since version 4.0 came out I have not been able to access the database
> >> and digikam eventually tells me the application is not responding.
> >> 
> >> my digikam version is now: still fails. It does pass the connection
> >> test, OK. If I drop back to version 3.5.0. everything was working with
> >> mysql located on localhost.
> >> 
> >> Don't know if this will help.
> >> 
> >> Russ
> > 
> > I had a similar problem with the mysql-Database since v. 4.1.0 came out.
> > DK still was working but if I tried to change something in the settings,
> > DK occupied one core completely and hung. After all I reinstalled DK
> > from scratch using an sqlite database, which works fine. So I suppose
> > something is wrong with the mysql schema in DK since 4.1.0
> > 
> > _______________________________________________
> > Digikam-users mailing list
> > Digikam-users at kde.org
> > https://mail.kde.org/mailman/listinfo/digikam-users
> 
> _______________________________________________
> Digikam-users mailing list
> Digikam-users at kde.org
> https://mail.kde.org/mailman/listinfo/digikam-users