On Tue, Oct 16, 2012 at 1:32 AM, Alan Ezust <alan.ez...@gmail.com> wrote: > > > On Mon, Oct 15, 2012 at 12:32 PM, Matěj Laitl <ma...@laitl.cz> wrote: >> >> On 15. 10. 2012 Alan Ezust wrote: >> > I was running a build of amarok from GIT from a month ago. I thought I'd >> > rebuild the current trunk and try that. >> > So I did a git pull yesterday and rebuilt everything. >> > >> > Now all the ratings I had set in the amarok database (external mysql) >> > are >> > gone. >> > >> > Any way to get them back? >> > I see the "statistics" table still has 22000 rows in it, >> >> Then they are definitely not gone. Amarok deletes statistics for >> unreachable >> tracks on startup, so the tracks are there too. How many rows do you have >> in >> tracks table and how many tracks are physically in your collection? >> > > 22000 approx. I should have been more precise in my previous message. > I don't know if the ratings are "gone", I just know that I do not see stars > stars for the ratings in the playlist view anymore. > > >> >> > but there is a new >> > "statistics_permanent" table with only 315 rows. >> >> Unrelated and certainly not new. >> >
Note that using an external MySql and git versions is a recipe for losing database content. If you want to keep testing git versions (which we welcome very much) I suggest you switch back to mysqle and make regular backups of the database, at least for every time you update a git revision. I've attached a script that I use to back-up mine before I run a version with database changes.
backup_userdata.sh
Description: Bourne shell script
_______________________________________________ Amarok mailing list Amarok@kde.org https://mail.kde.org/mailman/listinfo/amarok
