I was having a bunch of trouble today importing my old MySQL amarok database into the new nightly version of amarok I installed.
The Amarok Wiki had a great section on how to convert a MySQL Amarok collection into an SQLlite one. This was the key to importing my old 1.4 collection into the new 2.2 nightly version of Amarok.