Maybe you ran out of room and bought yourself a new drive for all those music files. How do you tell MediaMonkey to look for the files on the new drive?
The MediaMonkey knowledgebase includes an entry on this subject, but I didn't feel safe monkeying around with the drive serial number - I didn't know what might break! So instead I came up with this alternate method.
The information provided below is not guaranteed in any way - Do this at your own risk!
Go to a DOS prompt.
Change to the new drive (example: "N:").
Type dir
The serial number should be in a form like this: 563A-FE37.
Use the handy utility below. You may end up with a negative number. That's fine - if it's negative you'll have to enter it that way later in Step 5.
For MediaMonkey 3.0 you can find the database at the following location:
| Windows XP | C:\Documents and Settings\<USERNAME>\Local Settings\Application Data\MediaMonkey\MM.DB |
| Windows Vista | C:\Users\<USERNAME>\AppData\Local\MediaMonkey\MM.DB |
Make a copy of it in case anything goes wrong!
MediaMonkey uses a SQLite database. In addition to the songs it also keeps track of the disks the songs are on. Here's where you will change the disk serial number so MediaMonkey will look for your songs on your new disk.
First download the free SQLite Database Browser from SourceForge. There is no real "install" process for this - what you're downloading is simply a zip file with a single executable program file inside.
Run the SQLite Browser and open the MediaMonkey database.
Click the Browse Data tab and choose the Medias table. Find your old drive, which you should be able to identify by the Label. Doubleclick on the SerialNumber field and change the serial number to the decimal number you got in Step 2.
While you're at it also change the Label and ShowLabel fields.
Using the horizontal scroll bar, go to the last field on the right, DriveLetter and change it if you need to. Use the table below to determine what number to put in the field.
| Your Drive Letter | DriveLetter Value |
|---|---|
| C: | 2 |
| D: | 3 |
| E: | 4 |
| F: | 5 |
| G: | 6 |
| H: | 7 |
| I: | 8 |
| J: | 9 |
| K: | 10 |
| L: | 11 |
| M: | 12 |
| N: | 13 |
| O: | 14 |
| P: | 15 |
| etc... | |
In this example the original DriveLetter (6) shows that my old drive was G:. If my new drive is K: I would change the field to a 10.
Now close SQLite Browser and restart MediaMonkey.
In case anything went wrong you can always revert to the database backup file you made in Step 3.
If you moved your files to a new folder on the new drive you would think you could fix this by doing a query to alter the SongPath field in the Songs table, something like:
UPDATE Songs SET SongPath = Replace(SongPath, ':\OldPath\Music\', ':\NewPath\Music\');
Unfortunately if you try this (using the sqlite3 command line tool, which supports the
replace() function) you end up with the error:
no such collation sequence: IUNICODE
Unfortunately, as detailed in a thread in the MediaMonkey forum, the developers had to add a custom collation function in order to get things to sort correctly using Unicode. This is a part of the MediaMonkey code, but will not be a part of any SQLite tools you may use. This means you're out of luck as far as updating most text data in the db.
So if you changed path you may need to rely on MediaMonkey Gold's Locate Moved/Missing Tracks function under the File menu.