Hi,

I had a disk crash. To make matters much worse, my local backup disk turned out to be corrupted as well. It has taken me 2 months to piece my computer and all its files back together (using a couple of off-site backups, and analysis of files recovered from the dud disks (using parted and other tools).

Anyway, the result is that I have my music (in a new location) and my old Amarok files, but when I try to put the 2 together I gets lots of errors. So I have rescanned my collection.

My question is - is there any way to import all my file star ratings?

Could you be a tad more specific about the Amarok versions you use and the version your backups are from?

I'm now using whatever comes with openSUSE 12.1 - rpm reports amarok-2.5.0-18.2.x86_64.

I was using openSUSE 11.4. Luckily I took a copy of my rpm list on the computer before it crashed. It was using amarok-2.4.0-8.11.3.x86_64.

If you have a backup of your previous database you should just be able to use that one.

I had already tried that. I restored the backup of .kde4/share/apps/amarok/ and then got the following errors (but perhaps my backup is incomplete):

The amarok database reported the following errors:
GREPME MySQLe query failed! (29) File '/home/djm/.kde4/share/apps/amarok/mysqle/amarok/urls.MYD' not found (Errcode: 2) 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! (29) File '/home/djm/.kde4/share/apps/amarok/mysqle/amarok/urls.MYD' not found (Errcode: 2) on CREATE UNIQUE INDEX urls_id_rpath ON urls(deviceid, rpath);
GREPME MySQLe query failed! (29) File '/home/djm/.kde4/share/apps/amarok/mysqle/amarok/urls.MYD' not found (Errcode: 2) on CREATE INDEX urls_uniqueid ON urls(uniqueid);
GREPME MySQLe query failed! (29) File '/home/djm/.kde4/share/apps/amarok/mysqle/amarok/urls.MYD' not found (Errcode: 2) on CREATE INDEX urls_directory ON urls(directory);
GREPME MySQLe query failed! (1017) Can't find file: 'artists' (errno: 2) on CREATE TABLE artists (id INTEGER PRIMARY KEY AUTO_INCREMENT,name VARCHAR(255) NOT NULL) COLLATE = utf8_bin ENGINE = MyISAM;
GREPME MySQLe query failed! (1017) Can't find file: 'artists' (errno: 2) on CREATE UNIQUE INDEX artists_name ON artists(name);
GREPME MySQLe query failed! (1017) Can't find file: 'images' (errno: 2) on CREATE TABLE images (id INTEGER PRIMARY KEY AUTO_INCREMENT,path VARCHAR(255) NOT NULL) COLLATE = utf8_bin ENGINE = MyISAM;
GREPME MySQLe query failed! (1017) Can't find file: 'images' (errno: 2) on CREATE UNIQUE INDEX images_name ON images(path);
GREPME MySQLe query failed! (29) File '/home/djm/.kde4/share/apps/amarok/mysqle/amarok/albums.MYD' not found (Errcode: 2) 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! (29) File '/home/djm/.kde4/share/apps/amarok/mysqle/amarok/albums.MYD' not found (Errcode: 2) on CREATE INDEX albums_name ON albums(name);
GREPME MySQLe query failed! (29) File '/home/djm/.kde4/share/apps/amarok/mysqle/amarok/albums.MYD' not found (Errcode: 2) on CREATE INDEX albums_artist ON albums(artist);
GREPME MySQLe query failed! (29) File '/home/djm/.kde4/share/apps/amarok/mysqle/amarok/albums.MYD' not found (Errcode: 2) on CREATE INDEX albums_image ON albums(image);
GREPME MySQLe query failed! (29) File '/home/djm/.kde4/share/apps/amarok/mysqle/amarok/albums.MYD' not found (Errcode: 2) on CREATE UNIQUE INDEX albums_name_artist ON albums(name,artist);
GREPME MySQLe query failed! (29) File '/home/djm/.kde4/share/apps/amarok/mysqle/amarok/genres.MYD' not found (Errcode: 2) on CREATE TABLE genres (id INTEGER PRIMARY KEY AUTO_INCREMENT,name VARCHAR(255) NOT NULL) COLLATE = utf8_bin ENGINE = MyISAM;
GREPME MySQLe query failed! (29) File '/home/djm/.kde4/share/apps/amarok/mysqle/amarok/genres.MYD' not found (Errcode: 2) on CREATE UNIQUE INDEX genres_name ON genres(name);
GREPME MySQLe query failed! (1017) Can't find file: 'labels' (errno: 2) on CREATE TABLE labels (id INTEGER PRIMARY KEY AUTO_INCREMENT,label VARCHAR(255)) COLLATE = utf8_bin ENGINE = MyISAM;
GREPME MySQLe query failed! (1017) Can't find file: 'labels' (errno: 2) on CREATE UNIQUE INDEX labels_label ON labels(label);
GREPME MySQLe query failed! (29) File '/home/djm/.kde4/share/apps/amarok/mysqle/amarok/statistics_permanent.MYD' not found (Errcode: 2) on CREATE TABLE statistics_permanent (url VARCHAR(324) NOT NULL,firstplayed DATETIME,lastplayed DATETIME,score FLOAT,rating INTEGER DEFAULT 0,playcount INTEGER) COLLATE = utf8_bin ENGINE = MyISAM;
GREPME MySQLe query failed! (29) File '/home/djm/.kde4/share/apps/amarok/mysqle/amarok/statistics_permanent.MYD' not found (Errcode: 2) on CREATE UNIQUE INDEX stats_perm_url ON statistics_permanent(url)
GREPME MySQLe query failed! (1017) Can't find file: 'statistics_tag' (errno: 2) on CREATE TABLE statistics_tag (name VARCHAR(108),artist VARCHAR(108),album VARCHAR(108),firstplayed DATETIME,lastplayed DATETIME,score FLOAT,rating INTEGER DEFAULT 0,playcount INTEGER) COLLATE = utf8_bin ENGINE = MyISAM
In most cases you will need to resolve these errors before Amarok will run properly.

Please have a look here on how to fix tables: http://amarok.kde.org/wiki/MySQL_Server ... d_Database

This is valid for both the default embedded MySQL and an external server.