Hi all. I'm hoping someone else may have come across this and found a solution. I wanted to convert my digikam setup from sqlite to mysql. Digikam includes a database migration tool so I; -Set up a user for digikam in mysql -Created 2 empty databases as required by digikam (one called digikam, one called thumbnails) -Granted global priveleges to the digikam user (UGLY! but it won't work otherwise - digikam complains that "CREATE TRIGGER" priveleges are not granted if you only grant database-level privleges) :-( -Configured digikam to talk to the correct mysql database -Clicked on "Test DB Connection" in Digikam and got "Database connection test successful". So far so good. Unfortunately, when trying to use the database migration tool, I get the an error message: "Error while creating the database schema". Go into mysql and confirm that "show tables;" in each database returns an empty result, so nothing has been created in the databases. OK, maybe digikam wants to create the databases itself..."drop database <dbname>;" - digikam then complains "Error opening target database". Recreate the databases, double check priveleges, still the same result. Running Digikam 2.3.0, KDE 4.6.5 on oS 11.4 with mysql 5.1.53. Has anyone gotten this to work recently? TIA, Rodney. PS There is an open bug for this - according to the bug report it was supposed to have been fixed in 2.0.0 (the bug was raised against 1.9.5) but it seems not to be fixed...it is also reported to work with Ubuntu but to be broken in Fedora and, it seems, oS. Perhaps there is something not correctly packaged... -- =================================================== Rodney Baker VK5ZTV rodney.baker@iinet.net.au =================================================== -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org To contact the owner, e-mail: opensuse+owner@opensuse.org