Change Path on all Links

Any trouble you encounter with the Pedias, here's the place to ask for help.

Change Path on all Links

Postby fabiopigi » Sun Jan 04, 2009 3:31 pm

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

Re: Change Path on all Links

Postby Conor » Sun Jan 04, 2009 6:10 pm

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.
User avatar
Conor
Top Dog
 
Posts: 5195
Joined: Sat Jul 03, 2004 12:58 pm

Re: Change Path on all Links

Postby fabiopigi » Mon Jan 05, 2009 8:23 am

thanks, it worked like charm
fabiopigi
Bruji Friend
Bruji Friend
 
Posts: 10
Joined: Sun May 18, 2008 9:15 am


Return to Support