Corrupted database

Post a reply

Smilies
:D :) :( :o :-? 8) :lol: :x :P :oops: :cry: :evil: :roll: :wink:

BBCode is ON
[img] is ON
[url] is ON
Smilies are ON

Topic review
   

Expand view Topic review: Corrupted database

Re: Corrupted database

by Peke » Mon Jul 25, 2022 3:52 pm

Barry4679 wrote: Mon Jul 25, 2022 8:10 am
Peke wrote: Sun Jul 24, 2022 9:18 am It is up to a debate there is extensive bug scheduled for MM 5.1 https://www.ventismedia.com/mantis/view.php?id=16176 Feel free to add what you think we are missing?
You need to unlock that issue ... Access Denied
Sorry, Corrected.

Re: Corrupted database

by Peke » Mon Jul 25, 2022 3:48 pm

Andre_H wrote: Mon Jul 25, 2022 8:39 am Then you probably have the hard drive capacity that 1 or 2 automatic backups wouldn't matter...
I do, but as my Backup location is on NAS, which even wired takes too much.

Re: Corrupted database

by Andre_H » Mon Jul 25, 2022 8:39 am

Peke wrote: Sat Jul 23, 2022 6:22 am Hmmm, Not sure I would like as my Library is 1.4GB :)
Then you probably have the hard drive capacity that 1 or 2 automatic backups wouldn't matter... :wink:
Peke wrote: Sat Jul 23, 2022 6:22 am I still prefer Manual backup, whenever I want.
Sometimes you NEED a backup without knowing about it beforehand, and having an automatically generated one then seems a lot better then just learning about this feature in THAT moment.

I agree with Barry, enabling database backup for a few copies by default makes sense. :wink:

Re: Corrupted database

by Barry4679 » Mon Jul 25, 2022 8:10 am

Peke wrote: Sun Jul 24, 2022 9:18 am It is up to a debate there is extensive bug scheduled for MM 5.1 https://www.ventismedia.com/mantis/view.php?id=16176 Feel free to add what you think we are missing?
You need to unlock that issue ... Access Denied

Re: Corrupted database

by Peke » Sun Jul 24, 2022 9:18 am

Hi,
Barry4679 wrote: Sat Jul 23, 2022 10:10 pm touche. Acknowledged, but then ... isn't denial at the core of every Hoarder.
I would not expect anything less from you. :roll: :D :lol:
Barry4679 wrote: Sat Jul 23, 2022 10:10 pm I notice that you sidestepped the main point. ie whether a minimal backup scheme should be defaulted to on.
I think that Ventis is letting their customers down by having it default to off.
It is up to a debate there is extensive bug scheduled for MM 5.1 https://www.ventismedia.com/mantis/view.php?id=16176 Feel free to add what you think we are missing?

Re: Corrupted database

by Barry4679 » Sat Jul 23, 2022 10:10 pm

Rob_S wrote: Sat Jul 23, 2022 5:20 pm This does not explain why OP can't find any backups existing? Is it because his files are on the NAS?
I am expecting it is because MM5 defaults to having no backups. The user needs to know that it is there, that it is not in the place they probably expected (Tools>Options), and that they are exposed to loss (play counts & playlists) if they don't turn it on.
Compounded by the fact that the Getting Started material is really poor, and is not in your face when getting started.
Peke wrote: Sat Jul 23, 2022 4:30 pm Yes there is a name for such person, serious collector and DJ (for me better to say ex-DJ).
touche. Acknowledged, but then ... isn't denial at the core of every Hoarder. :D

I notice that you sidestepped the main point. ie whether a minimal backup scheme should be defaulted to on.
I think that Ventis is letting their customers down by having it default to off.

Re: Corrupted database

by Rob_S » Sat Jul 23, 2022 5:20 pm

Lowlander wrote: Sat Jul 23, 2022 2:47 pm Yes, it creates dated backups and you can restore from backup under Tools > Options > Manage database.
This does not explain why OP can't find any backups existing? Is it because his files are on the NAS?
"Library database C:/users/.......can't be opened. Would you like to create a new local library?
error executing sql pragma synchronous=database disk image is malformed (11,11)"

If I say no, then MM5 does not start. Another window pops up "Application error" and some other text
If I say yes, then it starts creating a new databse with no playlists and no play counts.
And for Darich, as above if you were let it load, and let it create new library, and then try to restore, does it offer to restore, or what happens???

Also, what happens if you attempt a manual backup - does a dated .db file then appear someplace??

Re: Corrupted database

by Peke » Sat Jul 23, 2022 4:30 pm

Barry4679 wrote: Sat Jul 23, 2022 8:19 am If your actual database is 1.45gb, you must have something like 500,000 tracks ? ... there must be a medical name for someone like that
206k to be precise. Library file size really depends on amount of metadata it contain and index size especially text/string index. Yes there is a name for such person, serious collector and DJ (for me better to say ex-DJ). But then I have <10 Movies in collection. NOTE that I worked on several radio stations and on building their archives, so in most cases I got their CDs and have backup of their library ;)

Re: Corrupted database

by Lowlander » Sat Jul 23, 2022 2:47 pm

Yes, it creates dated backups and you can restore from backup under Tools > Options > Manage database.

Re: Corrupted database

by Rob_S » Sat Jul 23, 2022 2:45 pm

I agree with that, and in spite of some confusion in my earlier postings, it seems to me autobackup should be enabled by default, and I also think the backups should appear somewhere people who do not have "show hidden files" enabled can still find them. Maybe a setting that must be chosen upon installation??

Can anyone who has had autobackup enabled confirm that it actually produced a series of dated .db files, contrary to OP post above??

Also, can anyone confirm if the original database does become corrupted, will the program offer to reload last previous backup, from users designated backup path?

Backups are important, particularly since the database contains basically all the "work and effort" the user has put into this program, and knowing that it can become irretrievably corrupted.

I think for some reason peke above was thinking of backing up his Library of tracks, which is a whole separate issue. It would not be unreasonable for the program to have such a feature built into it.

Re: Corrupted database

by Barry4679 » Sat Jul 23, 2022 8:19 am

Peke wrote: Sat Jul 23, 2022 6:22 amHmmm, Not sure I would like as my Library is 1.4GB :) There is number on To-Do bugs for improvements.

I still prefer Manual backup, whenever I want.
You mean your Collection is 1.45gb? ... if so, your database will be much smaller.
I have 50,000 tracks, and my database is only 145mb.
This is compacted to 127mb when it is backed up.

If your actual database is 1.45gb, you must have something like 500,000 tracks ? ... there must be a medical name for someone like that :D

Having multiple backup copies is a flyspeck in computer terms ... and MM5 can auto housekeep it down to just n copies.

IMO Manual backups suck.
MM5 should default to have backups set on, with the housekeeping set to retain something small, like 3 or 5 copies.

The current default has cost darich all his play count history, and his playlists too.

You good with that?

Re: Corrupted database

by Peke » Sat Jul 23, 2022 6:22 am

Rob_S wrote: Fri Jul 22, 2022 2:56 pm Also, ideally the backups should default to at least a subfolder of the selected folder, named backups.
I hope they look at this and make some improvements to this part of the program.
Hmmm, Not sure I would like as my Library is 1.4GB :) There is number on To-Do bugs for improvements.

I still prefer Manual backup, whenever I want.

Re: Corrupted database

by darich » Sat Jul 23, 2022 4:13 am

Just posting to confirm that MM5 has created no back ups with the date appended, despite me having the auto back up checked and settting it to retain 2 copies.

Re: Corrupted database

by darich » Sat Jul 23, 2022 3:29 am

Thanks for the replies.

I'll have a search on my entire networked system for any other databases.
And although I appear to have set the back up to be in the same location as the original, if they're suffixed with the date of back up, then they're not there.... They're somewhere else. There are no files with a date added to the end.

Thankfully it's just playlists that are gone along with track play counts. The music itself is still there and plays fine after MM5 creates a new database.

I'll have a thorough search and fingers crossed I find a backup I can restore.

Thanks again.

Re: Corrupted database

by Rob_S » Fri Jul 22, 2022 6:31 pm

My apologies regarding the naming of backup files, I see indeed that it already does that for me - confirmed.

I was going by the statement above he had auto-backup enabled and did not find any sequential files.

I did not have auto-backup enabled, and had not made any backups within the program.

I have very few playlists, and all my track info is saved to tags, so very easy to restore by re-scanning.

Top