[witty]

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

[Klojum]

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.

[witty]

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 supported) from https://sourceforge.net/projects/mwayne/...e/download

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

thanks

[Karellen]

What operating system on the laptop?

[witty]

win10

[Klojum]

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

[trogggy]

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.

[Klojum]

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.

[trogggy]

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.

[witty]

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 :-(

[trogggy]

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.

[witty]

sorry, completely forgot about this to follow-up.

To summarize:

• Windows10
  
• Kodi portable v18.5 (https://portableapps.com/node/54938)
  
• MySql portable mysql-8.0.16-winx64 (https://stackoverflow.com/questions/42045494/running-starting-mysql-without-installation-on-windows)
  

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?

[black_eagle]

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.