Amarok: how to recover statistics database lost in transition 2.9 -> 3.x

Help
1

Some time ago (I think january) Amarok, was updated in Debian, from 2.9.x to 3.x (now it is 3.2.2). After the upgrade Amarok no longer showed the things from the database (lyrics, listen counts, etc).

I would like to restore the statistics database but I did not find the steps. Could you point me to the right instructions, or provide some advice about how to work on this?

2

According to amarok - Debian Package Tracker, only 2.9.0 was ever packaged for Debian. That one was still KDE4/Qt4 based, so it is possible that the embedded mysql/mariadb database is at ~/.kde4/share/amarok/mysqle/ and it could be copied to ~/.local/share/amarok/mysqle and everything’s there. There should have been an automatic migration from KDE4 paths, but at least I haven’t tested if it works during this decade. (Or, might also be some Debian-specific issue.)

2 Likes
3

Thank you! It has worked. The path I found is ~/.kde/share/apps/amarok/mysqle/ . Never thought of this, I was expecting something with complicated database scripts.

I just checked a couple of songs and have:

  • listen dates (oldest I found is 2007!) and count
  • labels
  • own rating (stars) and some computed one.

I did not find any lyrics, I can’t say if they were lost now or much earlier.

Can I copy your reply to the similar thread I started on Lemmy?

4

Very good!
Sure thing, feel free to do so.