scb99 245 Posted June 15, 2022 Posted June 15, 2022 Is this actually as simple as (in principle, I'm making this up as I write) 1. Stop Emby 2. Move the data from the old location to the new location 3. Open library.db and run UPDATE MediaItems SET Path='newpath'|| SUBSTR(Path,8,99) [SQLLite yes so not CONCAT] WHERE SUBSTR(Path,1,7)='oldpath' 4 Start Emby ??
chef 3810 Posted June 15, 2022 Posted June 15, 2022 (edited) If you run the library scan after the restart, would that not apply the new locations. The library scan might take an extra moment to complete, but it should correct the db for you. Edited June 15, 2022 by chef 1
Abobader 3470 Posted June 15, 2022 Posted June 15, 2022 14 minutes ago, chef said: The library scan might take an extra moment to complete, but it should correct the db for you. +1 I do that all the time.
scb99 245 Posted June 15, 2022 Author Posted June 15, 2022 (edited) 23 minutes ago, Abobader said: +1 I do that all the time. But if you do that, you have to start from base zero in identifying all the contents, etc etc, surely? I have done that before, and that is what happened. The point is to retain all the "customisation". Edited June 15, 2022 by scb99 1
chef 3810 Posted June 15, 2022 Posted June 15, 2022 1 hour ago, scb99 said: But if you do that, you have to start from base zero in identifying all the contents, etc etc, surely? I have done that before, and that is what happened. The point is to retain all the "customisation". I think as long as the nfo's gets moved as well. But also if the entry itself already exists in the database, it would only be the path that gets updated. I'm about 90% certain.
scb99 245 Posted June 15, 2022 Author Posted June 15, 2022 @chef I dont use nfos... As far as the db is concerned, it's a delete and re-add. It's got no way to know it's the same material in a new location. I'm pretty sure my way will work, I might do a test run soon. 1
Happy2Play 9784 Posted June 16, 2022 Posted June 16, 2022 From database only setup, yes the users has to manually update the database for the moved media. If not it will be removed as it no longer exists in old location, then readded from new location causing complete lookup for metadata and images. So to keep the existing identified media, Path needs updating 1
greinhardt 4 Posted June 16, 2022 Posted June 16, 2022 It would be very useful to have an admin operation to move an item from one library to another, moving the files and updating the database.
Luke 42085 Posted June 16, 2022 Posted June 16, 2022 10 minutes ago, greinhardt said: It would be very useful to have an admin operation to move an item from one library to another, moving the files and updating the database. HI, yes, it's on the to do list. Thanks.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now