Kodi Community Forum
Kodi MySQL and offline library-copy - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: OS independent / Other (https://forum.kodi.tv/forumdisplay.php?fid=228)
+---- Thread: Kodi MySQL and offline library-copy (/showthread.php?tid=345495)

Kodi MySQL and offline library-copy - witty - 2019-07-18

Hi,

I just "upgraded" my local Kodi-library copies at home to a shared MySQL-library running on my QNAP-NAS.

I'm also running a portable Kodi version on a notebook (no admin rights) and want to use the shared LAN-library also locally/offline ...
I don't want to play the movies/TV-shows/music (as the big files are located on my local NAS) - but I want to have access to the movie list and playinfo/pictures etc. offline
=> so I think I need an SQLite-export (MyVideos116.db + MyMusic72.db) from my MySQL-library

any idea?

thanks
Michael

RE: Kodi MySQL and offline library-copy - Klojum - 2019-07-18

Why not run a MySQL server on your notebook as well, for local use only?
Then simply do a mysqldump from your NAS to your notebook.
It would avoid possible SQLite/MySQL conversion troubles.

RE: Kodi MySQL and offline library-copy - witty - 2019-07-19

(2019-07-18, 17:21)Klojum Wrote: Why not run a MySQL server on your notebook as well, for local use only?
This was a very good question :-) Thought it is much more effort, but it was done in few minutes ...

... but now I have issues with my portable kodi-version, as it is ignoring the advancedsettings.xml file with the MySQL-connection info!
As I have no admin rights I installed a portable version (officially supportedHuh) from https://sourceforge.net/projects/mwayne/files/KodiPortable/KodiPortable_18.3_Dev_Test_1.paf.exe/download

... or is there any other way to install Kodi without admin-rights?

thanks

RE: Kodi MySQL and offline library-copy - Karellen - 2019-07-19

What operating system on the laptop?

RE: Kodi MySQL and offline library-copy - witty - 2019-07-19

win10

RE: Kodi MySQL and offline library-copy - Klojum - 2019-07-19

You don't need a .paf portable Kodi installer.
If you install the official Kodi version, and run it as portable, all should work.™

RE: Kodi MySQL and offline library-copy - trogggy - 2019-07-19

(2019-07-19, 14:18)Klojum Wrote: You don't need a .paf portable Kodi installer.
If you install the official Kodi version, and run it as portable, all should work.™
Can you do that without admin rights?  I'd assume not.

RE: Kodi MySQL and offline library-copy - Klojum - 2019-07-19

(2019-07-19, 14:56)trogggy Wrote: Can you do that without admin rights?  I'd assume not.

I do not have enough Windows 10 experience to know the different outcomes with and without admin rights.

RE: Kodi MySQL and offline library-copy - trogggy - 2019-07-19

(2019-07-19, 15:20)Klojum Wrote: I do not have enough Windows 10 experience to know the different outcomes with and without admin rights. 
Me neither.  If he can use kodi from here it's a no-brainer, but you do need to install Visual C++ which I guess is the issue.

RE: Kodi MySQL and offline library-copy - witty - 2019-07-19

exactly!

I can confirm, running Kodi installation is asking for admin rights immediately - decision to install in portable directory comes after having logged in with admin rights :-(

RE: Kodi MySQL and offline library-copy - trogggy - 2019-07-19

Enable debug logging, restart kodi, post the log to a paste site and the link here - that might show up why advancedsettiungs are not being read.

RE: Kodi MySQL and offline library-copy - witty - 2020-01-28

sorry, completely forgot about this to follow-up.

To summarize: I imported the Kodi databases from my Kodi/MySql live environment and hoped, that I then can see my library then in my "offline" environment.
But obviously, once the directory access is broken, all the database-data is being ignored.

Any hint how to create this kind of offline-environment?

RE: Kodi MySQL and offline library-copy - black_eagle - 2020-01-29

Hmmm, define "database-data".  Do you mean all the actual titles, or do you mean all the art ?  If it's the art that's missing, that's because Kodi only stores links to the art in the music/video dbs. If Kodi has shown the art before, it'll look in its local cache first and if its not there, then it will try to load it from the link(s).  Copying the Textures13.db and the entire Thumbnail directory from your live environment to the offline one might fix that.  Obviously, art that cannot be loaded from the cache will be missing as the sources are not available to load it from.