Database Corruption - Create Backup Feature?

[Justin Gray]

Original Post: http://www.mixxx.org/forums/viewtopic.php?f=1&t=8086

Hi all,

HP G71 Series Laptop
Pentium Dual Core 2.1Ghz
4 Gb Ram
Windows 7 Pro 64b
USB Ver. 2.0

MIXXX 1.11
External HDD for Music USB 3.0

I have not had this issue before and I am unsure what caused it but will keep tabs on it if it happens again. Started using Mixxx 1.11 6 months ago.

---Original Post:---
Recently I tried setting up for a gig and I loaded mixxx, and noticed it took a very long time to load. I then tried using the software and also noticed that AutoDJ would repeat the same song even though there were over 100 songs listed. I tried removing the one song in AutoDJ and after "Right Click -> Remove" the song stayed in the list. I tried this about 5 times. I then tried removing the entire AutoDJ list and "Right Click -> Remove" everything stayed. AutoDJ was rendered useless. Could not add or remove tracks.

I then looked at the mixxxdb.sqlite file from directory "user/appdata/local/mixxx" and noticed it was much larger than it should have been 60,676KB verses the new 1,992 KB file. there are some playlists not loaded into the new database but those are small and seasonal.

So to remedy the issue I deleted the mixxxdb.sqlite file from directory "user/appdata/local/mixxx" and started a fresh one which meant I needed to reload all the playlists again which I have exported. Mixx now loads up MUCH faster and AutoDJ works fine.

Those exported playlists are also a little dated so they don't have all the updated songs I have been adding over a couple months or so.

To make life a little easier in this event...I created a backup of the mixxxdb.sqlite file.

So my question to the developers is... Could you create a Database Backup option? Manual and Automatic? Automatic may just pop up a small message at the bottom right corner of the screen asking to backup the database, this would give you the reminder and option to say yes or no depending on how good you know the database is. Maybe have a 3rd option in that massage for "remind me in 10 minutes" as the "default" highlighted option. This way if the DJ is typing and this message pops ups above MIXXX, and the dj doesn't notice and presses a key which actuates an option on the reminder window, it defaults to "Remind Me" and comes back a little later, Or just make sure the reminder window doesnt steel the spot light from mixxx and the user needs to click on the message window in order to user the keyboard or mouse to actuate any of the yes/no/remind me options.

[Swiftb0y (swiftb0y)]

Mixxx now uses GitHub for bug tracking. This bug has been migrated to:
https://github.com/mixxxdj/mixxx/issues/8493