Note to self: digikam 1.8 with mysql instead of sqlite

When migrating the DB from sqlite to mysql does not work (Beim Erstellen der Tabellen in der Datenbank ist ein Fehler aufgetreten.” or ) , edit the edit the /usr/share/kde4/apps/digikam/database/dbconfig.xml configuration file as root and

557c557
<                             UNIQUE(albumRoot, relativePath(255)));</statement>
---
>                             UNIQUE(albumRoot, relativePath(332)));</statement>
567c567
<                             UNIQUE (album, name(255)));</statement>
---
>                             UNIQUE (album, name(332)));</statement>
651c651
<                             UNIQUE (imageid, property(255)));</statement>
---
>                             UNIQUE (imageid, property(332)));</statement>
667c667
<                             UNIQUE(keyword(255)));</statement></dbaction>
---
>                             UNIQUE(keyword(333)));</statement></dbaction>                                                                                   
875c875                                                                                                                                                       
<                             UNIQUE(path(254)))
---
>                             UNIQUE(path(333)))
880c880
<                             UNIQUE(keyword(254)))
---
>                             UNIQUE(keyword(333)))

found this by

export MYSQL D_ DEBUG=yes
/etc / init.d / mysql restart
and 
checking the mysqld-query.log  log 

(which then did not work because the permissions were wrong for the mysql log folder until I fixed them.)