I recently upgrade to KDE 5. I was able to get my Amarok music collection back, but all my stats are gone. Ive been trying to use the Import feature in Amarok settings, but it keeps asking for an .xml file which doesnt exist anywhere on my computer. I tried simply copying over the Amarok file in .kde/share/apps from my backups, but that results in Amarok crashing complaining about mysql problems. How can I import my collection with statistics in KDE 5?

Could you please provide the exact error message you get? Also please check you have all mysql packages required, especially for MySQL embedded. Also specifying your distribution could be useful...

Heres the error message I get when trying to open Amarok with my old amarok file.

Code: Select all

The amarok database reported the following errors:
GREPME MySQLe query failed! (1) Can't create/write to file '/home/zachleigh/.kde/share/apps/amarok/mysqle/amarok/db.opt' (Errcode: 13) on Could not alter database charset/collation
GREPME MySQLe query failed! (1) Can't create/write to file '/home/zachleigh/.kde/share/apps/amarok/mysqle/amarok/admin.MYI' (Errcode: 13) on CREATE TABLE admin (component VARCHAR(255), version INTEGER) COLLATE = utf8_bin ENGINE = MyISAM;
GREPME MySQLe query failed! (1) Can't create/write to file '/home/zachleigh/.kde/share/apps/amarok/mysqle/amarok/devices.MYI' (Errcode: 13) on CREATE TABLE devices (id INTEGER PRIMARY KEY AUTO_INCREMENT,type VARCHAR(255),label VARCHAR(255),lastmountpoint VARCHAR(255),uuid VARCHAR(255),servername VARCHAR(80),sharename VARCHAR(240)) COLLATE = utf8_bin ENGINE = MyISAM;
GREPME MySQLe query failed! (1146) Table 'amarok.devices' doesn't exist on CREATE INDEX devices_type ON devices( type );
GREPME MySQLe query failed! (1146) Table 'amarok.devices' doesn't exist on CREATE UNIQUE INDEX devices_uuid ON devices( uuid );
GREPME MySQLe query failed! (1146) Table 'amarok.devices' doesn't exist on CREATE INDEX devices_rshare ON devices( servername, sharename );
GREPME MySQLe query failed! (1050) Table 'urls' already exists on CREATE TABLE urls (id INTEGER PRIMARY KEY AUTO_INCREMENT,deviceid INTEGER,rpath VARCHAR(324) NOT NULL,directory INTEGER,uniqueid VARCHAR(128) UNIQUE) COLLATE = utf8_bin ENGINE = MyISAM;
GREPME MySQLe query failed! (1061) Duplicate key name 'urls_id_rpath' on CREATE UNIQUE INDEX urls_id_rpath ON urls(deviceid, rpath);
GREPME MySQLe query failed! (1061) Duplicate key name 'urls_uniqueid' on CREATE INDEX urls_uniqueid ON urls(uniqueid);
GREPME MySQLe query failed! (1061) Duplicate key name 'urls_directory' on CREATE INDEX urls_directory ON urls(directory);
GREPME MySQLe query failed! (1050) Table 'directories' already exists on CREATE TABLE directories (id INTEGER PRIMARY KEY AUTO_INCREMENT,deviceid INTEGER,dir VARCHAR(1000) NOT NULL,changedate INTEGER) COLLATE = utf8_bin ENGINE = MyISAM;
GREPME MySQLe query failed! (1061) Duplicate key name 'directories_deviceid' on CREATE INDEX directories_deviceid ON directories(deviceid);
GREPME MySQLe query failed! (1050) Table 'artists' already exists on CREATE TABLE artists (id INTEGER PRIMARY KEY AUTO_INCREMENT,name VARCHAR(255) NOT NULL) COLLATE = utf8_bin ENGINE = MyISAM;
GREPME MySQLe query failed! (1061) Duplicate key name 'artists_name' on CREATE UNIQUE INDEX artists_name ON artists(name);
GREPME MySQLe query failed! (1050) Table 'images' already exists on CREATE TABLE images (id INTEGER PRIMARY KEY AUTO_INCREMENT,path VARCHAR(255) NOT NULL) COLLATE = utf8_bin ENGINE = MyISAM;
GREPME MySQLe query failed! (1061) Duplicate key name 'images_name' on CREATE UNIQUE INDEX images_name ON images(path);
GREPME MySQLe query failed! (1050) Table 'albums' already exists on CREATE TABLE albums (id INTEGER PRIMARY KEY AUTO_INCREMENT,name VARCHAR(255) NOT NULL,artist INTEGER,image INTEGER) COLLATE = utf8_bin ENGINE = MyISAM;
GREPME MySQLe query failed! (1061) Duplicate key name 'albums_name' on CREATE INDEX albums_name ON albums(name);
GREPME MySQLe query failed! (1061) Duplicate key name 'albums_artist' on CREATE INDEX albums_artist ON albums(artist);
GREPME MySQLe query failed! (1061) Duplicate key name 'albums_image' on CREATE INDEX albums_image ON albums(image);
In most cases you will need to resolve these errors before Amarok will run properly.

I have mysql installed, so I think I have all dependencies filled. libmysqld-pic is the necessary mysql embedded package, right?
Im running Kubuntu 15.04 with KDE 4.14.8. Amarok version is 2.8.0.