Amarok crashed on me and now, whenever I start it up, I get this message:

Code: Select all

The amarok database reported the following errors:
GREPME MySQLe query failed! (1194) Table 'albums' is marked as crashed and should be repaired on DELETE FROM albums WHERE id NOT IN ( SELECT album FROM tracks WHERE album IS NOT NULL )
In most cases you will need to resolve these errors before Amarok will run properly.

Weirdly, it seems to run just fine, except for giving me that error on startup. But I'd like to fix it anyway, and I have no problem running that SQL query ... except I have no idea where to run it. If I were using an external MySQL server I'd know, of course, but I don't know how to send queries to the embedded server. I Googled a bit but didn't see anything promising.

Can anyone tell me how to accomplish this?

You can just remove the database. It's in ~/.kde/share/apps/amarok/mysqle (may be .kde4 on some distros). Note this will lose your statistics etc.
It is possible to connect to the embedded database like any MySQL database and attempt manual recovery if you prefer, but there may well be irrecoverable data loss anyway.

Sentynel wrote:You can just remove the database. It's in ~/.kde/share/apps/amarok/mysqle (may be .kde4 on some distros). Note this will lose your statistics etc.
It is possible to connect to the embedded database like any MySQL database and attempt manual recovery if you prefer, but there may well be irrecoverable data loss anyway.

Gotcha. I tried a repair using myisamchk, which got rid of the startup errors, but you were right about the data errors: I kept seeing the wrong album name on songs in playlists and stuff like that, so I went ahead and removed the whole dir. That fixed the data errors, but I did get one odd dialog box from the collection scanner whining about duplicate UUIDs. I told it to do do a full rescan, so we'll see if that takes care of it.

Just out of curiosity, if I did want to connect to the embedded MySQL, what would the connection info be? DBname, port, username/password, that sort of thing?

Thanx for the quick response!

http://amarok.kde.org/wiki/Development/ ... edded#Tips
The tips section here gives instructions for starting a MySQL daemon with the embedded database.

Sentynel wrote:http://amarok.kde.org/wiki/Development/MySQL_Embedded#Tips
The tips section here gives instructions for starting a MySQL daemon with the embedded database.

Got it. Thanx again!