home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 1
MediaPortal 1 Plugins
Popular Plugins
Moving Pictures
How to change path in DB
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="mjmapi" data-source="post: 1093243"><p>This might be old, but for some that still go through this headache every-time they make changes to their drives, the DB edit route always proves easier for me.In my case i was changing my paths to a network share</p><p></p><p>to edit the TV Series DB, two tables must be edited</p><p></p><p>update local_episodes</p><p>set EpisodeFilename = replace(EpisodeFilename, 'D:\Series', '\\192.168.2.197\Series\Series')</p><p></p><p>update local_episodes</p><p>set volumelabel = replace(volumelabel, 'Series', '192.168.2.197\Series\Series')</p><p>//my old local folder drive was named series, this must also be changed to the network folder, don't include the '\\' </p><p></p><p>update importpathes</p><p>set path = replace(path, 'D:\Series', '\\192.168.2.194\Series\Series')</p><p></p><p>you can run some selects on the following tables to verify that all has been changed</p><p></p><p>select * from</p><p>local_episodes</p><p></p><p>Select * </p><p>from importpathes</p><p></p><p></p><p>Make Changes to the Moving pictures Db</p><p></p><p>update local_media</p><p>set fullpath = replace(fullpath, '\\E:\Movies','\\192.168.2.197\Media\Movies\Various')</p><p>//This changes the file-names prefix, appending it with the new path</p><p></p><p>update import_path</p><p>set path = replace(path, 'E:\Movies','\\192.168.2.197\Media\Movies\Various')</p><p></p><p>update local_media</p><p>set volume_serial = ''</p><p>//My local was set to Movies, the name of my HardDrive, i removed this</p><p></p><p>Hope this helps someone that might have also struggled as i did</p></blockquote><p></p>
[QUOTE="mjmapi, post: 1093243"] This might be old, but for some that still go through this headache every-time they make changes to their drives, the DB edit route always proves easier for me.In my case i was changing my paths to a network share to edit the TV Series DB, two tables must be edited update local_episodes set EpisodeFilename = replace(EpisodeFilename, 'D:\Series', '\\192.168.2.197\Series\Series') update local_episodes set volumelabel = replace(volumelabel, 'Series', '192.168.2.197\Series\Series') //my old local folder drive was named series, this must also be changed to the network folder, don't include the '\\' update importpathes set path = replace(path, 'D:\Series', '\\192.168.2.194\Series\Series') you can run some selects on the following tables to verify that all has been changed select * from local_episodes Select * from importpathes Make Changes to the Moving pictures Db update local_media set fullpath = replace(fullpath, '\\E:\Movies','\\192.168.2.197\Media\Movies\Various') //This changes the file-names prefix, appending it with the new path update import_path set path = replace(path, 'E:\Movies','\\192.168.2.197\Media\Movies\Various') update local_media set volume_serial = '' //My local was set to Movies, the name of my HardDrive, i removed this Hope this helps someone that might have also struggled as i did [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
MediaPortal 1 Plugins
Popular Plugins
Moving Pictures
How to change path in DB
Contact us
RSS
Top
Bottom