I've had similar problems with amarok after upgrading mysql, and it's
not for the first time. At some point I just said "screw you", dropped
the whole database and started from scratch (amarok previously wiped out
its statistics a couple of times for me, right now I don't really care
that much any longer).

Duncan wrote:
 > Or, if you don't have any particular attachment to MySQL, try turning off
> that USE flag.  I don't have either that or postgres turned on or merged,
> and amarok still seems to manage its database.

If both mysql and postgres are disabled amarok falls back to using a
sqlite database.