I have two osmc boxes. First is a pi3 that I’ve used for years. Second is brand new Vero 4k+. I want to share a library between them. Files are located on USB drive hooked directly to pi3. I used osmc sharing and mounted the USB to /home/osmc/videos. After setting SMB to v1, can navigate to this folder via SMB browse on Add Videos. Removed local paths on pi3, added the movie and TV shows paths using this SMB location and rebuilt library. Followed instructions in this thread:
Didn’t bother to add a database entry for music or pictures because I don’t use those functions. Only other edit is to increase items in recently added (has worked for forever). I copied this, sources.xml and the Thumbs13.db to the Vero after exporting the library.
The problem is with the videodatabase section of the advancedsettings.xml file. After rebooting I got a black screen. I deleted that section via ssh and rebooted again and all is well again, library still there and working.
When I followed the instructions on the Kodi wiki about MySQL it said to reimport the library. I navigated to the smb folders for Movies and TV Shows individually and hit okay and nothing seemed to happen for either.
If the library on your Pi is setup and working with MySQL then your Vero should be able to use the exact same advancedsetting file. You can actually just copy the entire userdata folder if you wanted. At least it works this way duplicating my profiles between my PC and Pi’s so the Vero should be no different.
(regarding the “name” tag the kodi devs have recommended NOT setting it for years now unless you need to run more than one independent database)
You would not copy the Thumbs13.db unless you are also moving the thumbnails folder. You don’t actually have to copy either as it will automatically populate the thumbnails from the source listed in the database.
Got “command not found” so I installed the client, then verified the database was there.
Since I didn’t think the library import command worked, I removed the sources and re-added them and rebuilt my library. I then re-added the videodatabaze section and rebooted and it came back! I’m cleaning up the bad scrapes now and then copying the stuff over to the other box. Fingers are crossed.
Is it possible to copy the whole user folder or something to literally copy every skin/widget setting?
It was a bit late when I replied to your pm last night so I didn’t fully catch on to what was going on. Your issue with trying to import was that you used the separate file export. Kodi will only import a library how you were expecting if you do a single file export. When you do the separate file export you have to add sources and rescrape as if you were setting up a brand new install.
The situation you were working with however required a separate file export. With a single file export from your original SQLite database it would have had the original (local) sources which would have been incorrect with your new setup. What you would have ended up with is a populated library with all the sources working on your Pi and not working on your Vero.
Single file export contains path info, Seperate file export does not. If your paths are going to be different (which they were) then you cannot use the import library function.
Okay, so I decided to clear out my textures (had tons of orphaned ones) and noticed something possibly unrelated but terrible. When in TV Shows, opening a show gets me a “Working” for between 5 and 15 seconds for any show. I don’t know if I remember ever seeing this message before I moved to a MySQL DB. Is this a byproduct of that or is something else going on here?
Edit: Same behavior after rebooting, by the way.
Edit 2: Googling shows this is common in that Kodi just struggles with TV Shows in particular. Should I move the MySQL DB to the Vero 4k+ rather than the pi3? I really don’t want to have a Windows box running 24/7, so I wanted to house it on one of these energy efficient options.