Hi RoJeC,
You are right about everything. People should really know what they're doing and know some basics of directory/folder structure of Windows and Mac/Unix.
Most of my files were indeed in the same root folder, so I could just do:
- Code: Select all
sqlite> UPDATE Music SET fullpath = REPLACE(fullpath,"F:\music\","/Volumes/Iomega HDD/music/");
Of course, this only changes the root and not all underlying subfolders, which still have the windows slash "\" that needs to be changed to a mac/unix slash "/". Therefore I did this too:
- Code: Select all
sqlite> UPDATE Music SET fullpath = REPLACE(fullpath,"\","/");
You have to do these commands to each root folder, logically.
And sure, the location of the database files can be different. Depends indeed on where you saved them, if you did.
Anyway, this is the only way I could migrate my entire collection from Windows to Mac, since Relocate did nothing. Some work still required there. Although I think Relocate might work fine when you stay on the same OS, it was not designed to work when switching OS'es. At least that's my thought.