Change Path on all Links

[fabiopigi]

hi

i've linked almost all of my movies in DVDpedia with links to the moviefile.
i used to have the movies on an external drive.
i've moved them now all on an internal drive, and therefore, all the pathes are incorrect now.

only the name of the Volume changed, but its enough to confuse DVDpedia.

i've tried to open the dvdpedia database with sqlite database viewer which worked, however i dont know the SQL command to update all the pathed to the new one.


any idea?

[Conor]

In Terminal use:

Code: Select all

sqlite3 ~/Library/Application\ Support/DVDpedia/Database.dvdpd
update ZLINK Set ZURL = replace(ZURL, 'file:///Volumes/MyOldMovieDrive', 'file:///Volumes/MyNewMovieDrive');
.exit

Otherwise just the middle line in an SQLite application. More detailed info here and here.

[fabiopigi]

thanks, it worked like charm