Change Path on all Links

Any trouble you encounter with the Pedias, here's the place to ask for help.
Post Reply
fabiopigi
Bruji Friend
Bruji Friend
Posts: 10
Joined: Sun May 18, 2008 9:15 am

Change Path on all Links

Post by 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?
User avatar
Conor
Top Dog
Posts: 5343
Joined: Sat Jul 03, 2004 12:58 pm
Contact:

Re: Change Path on all Links

Post by 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
Bruji Friend
Bruji Friend
Posts: 10
Joined: Sun May 18, 2008 9:15 am

Re: Change Path on all Links

Post by fabiopigi »

thanks, it worked like charm
Post Reply