Database crash: Fastest way to import tracks from scratch?

Get answers about using the current release of MediaMonkey for Windows.

Moderator: Gurus

MMuser2011
Posts: 1298
Joined: Mon Oct 17, 2011 8:28 am
Location: Central Europe

Database crash: Fastest way to import tracks from scratch?

Post by MMuser2011 » Thu Jun 28, 2012 6:07 am

Unfortunetaly, my MM.DB crashed with a 'database disk image is malformed'. All my last 7(!) Backups from this DB are corrupt too :evil: I can not run the Maintain Library Full option anymore...

Therefore I have to rebuild my entire database. If I re-scan all my tracks from the attached USB disks, it needs more then 5 full days (estimated time after two hours of import) :o Is there anything I can adjust to make the initial import MUCH faster?

Or can I manually INSERT some parts of data from the backuped MM.DB to speed up this process?

Any other ideas?
Magic Nodes v4.3.3 (2018-10-03) last free version SQL Viewer v2.4 (2009-10-25)
ExternalTools v1.4 (2011-05-09) iTunesMonkey 1.0 + Acoustid
Calculate Cover Size v1.7 (2012-10-23) RegExp Find & Replace v4.4.9 (2018-10-03) last free version

nohitter151
Posts: 23640
Joined: Wed Aug 09, 2006 10:20 am
Location: NJ, USA
Contact:

Re: Database crash: Fastest way to import tracks from scratc

Post by nohitter151 » Thu Jun 28, 2012 11:29 am

MediaMonkey user since 2006
Need help? Got a suggestion? Can't find something?

Please no PMs in reply to a post. Just reply in the thread.

MMuser2011
Posts: 1298
Joined: Mon Oct 17, 2011 8:28 am
Location: Central Europe

Re: Database crash: Fastest way to import tracks from scratc

Post by MMuser2011 » Thu Jun 28, 2012 11:42 am

Thank you for this info, nohitter151!

In the meantime I was able to speed up the import "dramatically" :wink: . It should no more need 5 full days. Actually, the estimated time of completion is about 20 hours.

What I did:
- Excluded all the \mp3-directories on my external USB discs from Antivirus checking
- Changed the priority for "MediaMonkey.exe" with sysinternals process explorer to the highest possible 'Realtime: 24' (can still work on my machine)
- deactivated "Analyze files for duplicates (takes extra time)" from menu 'Options', 'Library'
- clicked on a node that does not refresh for every newly added entry (-> Magic Node or you can use 'Entire Library' -> 'Files to edit')

Lets hope that I have my collection back tomorrow evening at the same time. 8)
Magic Nodes v4.3.3 (2018-10-03) last free version SQL Viewer v2.4 (2009-10-25)
ExternalTools v1.4 (2011-05-09) iTunesMonkey 1.0 + Acoustid
Calculate Cover Size v1.7 (2012-10-23) RegExp Find & Replace v4.4.9 (2018-10-03) last free version

MMuser2011
Posts: 1298
Joined: Mon Oct 17, 2011 8:28 am
Location: Central Europe

Re: Database crash: Fastest way to import tracks from scratc

Post by MMuser2011 » Fri Jun 29, 2012 4:18 am

After 22 hours, my database is up and running again! :D

Is there any script to generate the data in the skipped part "Analyze files for duplicates (takes extra time)" in a background process?
I have 8 cores in my cpu and at least 6 could calculate the hashes. Any idea, how this could be done?

Or is this really the only way to calculate the hash value?
Image
Magic Nodes v4.3.3 (2018-10-03) last free version SQL Viewer v2.4 (2009-10-25)
ExternalTools v1.4 (2011-05-09) iTunesMonkey 1.0 + Acoustid
Calculate Cover Size v1.7 (2012-10-23) RegExp Find & Replace v4.4.9 (2018-10-03) last free version

Lowlander
Posts: 46179
Joined: Sat Sep 06, 2003 5:53 pm
Location: MediaMonkey 5

Re: Database crash: Fastest way to import tracks from scratc

Post by Lowlander » Fri Jun 29, 2012 9:39 am

I think scanning is the only way.
Lowlander (MediaMonkey user since 2003)

Anamon
Posts: 76
Joined: Sat Jul 21, 2007 4:38 am
Location: Switzerland
Contact:

Re: Database crash: Fastest way to import tracks from scratc

Post by Anamon » Sun Jul 01, 2012 10:08 pm

If you deactivate "Update file info from Tags when rescanning files" your second scan should be much faster though, minus the fingerprinting going on. At least I hope fingerprinting will still happen then...

MMuser2011
Posts: 1298
Joined: Mon Oct 17, 2011 8:28 am
Location: Central Europe

Re: Database crash: Fastest way to import tracks from scratc

Post by MMuser2011 » Mon Jul 02, 2012 3:19 am

You are right, Anamon. It IS faster, but still needs days to complete in my environment.
Magic Nodes v4.3.3 (2018-10-03) last free version SQL Viewer v2.4 (2009-10-25)
ExternalTools v1.4 (2011-05-09) iTunesMonkey 1.0 + Acoustid
Calculate Cover Size v1.7 (2012-10-23) RegExp Find & Replace v4.4.9 (2018-10-03) last free version

Post Reply