I had the same problem.
Kubuntu 8.10, KDE 4.1.3, Amarok 2.0.
Solved by installing libqt4-sql-sqlite.
libqt4-sql-mysql was already installed.
However, all my titles are shown twice

I get the error

Error: Could not open Amarok 1.4 database: Unknown database 'amarokdb' QMYSQL: Unable to connect
Failed: Unable to import statistics

I have installed libqt4-sql-sqlite and i makes no difference.

My experience is exactly the one documented in bug 174269, I can log into the 1.4 database from the mysql console and see that it is there.

http://bugs.kde.org/show_bug.cgi?id=174269

I love 2.0 it looks cool, loads faster, responds faster in the UI, but I really need to access the 1.4 database to have access to my collection. What can I do to help resolve this issue.

The fact that it's a reported bug, and that the comments for the bug say it's being looked at, would indicate that the best thing you can do is what is suggested there - get some debug stuff happening and post backtraces from crashes to the bug report. The more cases with good debugging feedback, the more likely a result sooner rather than later.

Hi. Thanks for the great program!

I had the same problem importing Amarok 1.4 DB that show "Success: Imported 0 tracks" message.
I installed amarok 2.0 (build date: dec 10 2008) from debian experimental repository. My db was in mysql-server 5.0.67-2 at localhost, and id, password, database name was alright when I test with mysql-client.

While I read this thread, I got an idea when Seb Ruiz said...

Seb Ruiz wrote:I didn't have any problems running the importer. The database was, however, on another machine.

So I put my real host name in the "Hostname" field of the "Import Collection" dialog, instead of "localhost" which was the default value.
And it worked!

=================================================================================
....................
Imported 해바라기 - 안녕 내 사랑 (라이브 콘서트)
Imported 해바라기 - 오랜 침묵은 깨어지고 (라이브 콘서트)
Imported 해바라기 - 내마음의 보석상자 (라이브 콘서트)
Imported 해바라기 - 너 (라이브 콘서트)
Imported 해바라기 - 고개를 숙인 사람 (라이브 콘서트)
Imported 해바라기 - 사랑의 시 (라이브 콘서트)
Imported 해바라기 - 사랑은 언제나 그자리에 (라이브 콘서트)
Success: Imported 8,187 tracks
=================================================================================

I hope this could help you find the source of the bug.

Also, I had no problem importing files with characters like 해, の,  λ, שְׁ, ∀.