Mysql library: mygrating from kodi 14 to 17
#1
I used to have a kodibuntu with kodi 14/helix on a Lenovo PC, dedicated for kodi.

I have a separate "NAS" (raspberri Pi which is my print/file/...-server) with attached hard drive. This holds both my video files (accessible over NFS and SMB) and the kodi database on mysql.

However, trying to update kodibuntu, it a) removed kodi and b) the Lenovo's hard drive crashed.
So I put in a new hard drive and installed openelec instead

I added my video sources (movies and tv shows) and created a ~/.kodi/userdata/advancedsettings.xls with the following content
Code:
<advancedsettings>
  <videodatabase>
    <type>mysql</type>
    <host>192.168.15.2</host>
    <port>3306</port>
    <user>xbmc</user>
    <pass>xbmc</pass>
  </videodatabase>
  <videolibrary>
    <importwatchedstate>true</importwatchedstate>
    <importresumepoint>true</importresumepoint>
  </videolibrary>
</advancedsettings>

(I have checked that xbmc/xbmc is indeed the proper user/pass).

However, the new Kodi is scanning the database and not showing the "view status" of my old movies. I have the idea it is rebuilding the database entirely.
a) Are the databases from kodi 14 and 17 compatible?
b) I can't seem to remember the exact way of accessing the video libraries (whether I used SMB or NFS, and whether I used "TV Shows" or "Series" as a name. Is this important or is the library based on the video/tv show signature?
c[/code]) How can I check whether kodi indeed uses the external mysql database
d) how do I get my "view states" back? :-)
Reply
#2
Hah, I have self-fixed it. Posting it for future reference.

On the old "crashed" hard disk (it has errors writing to it, but I can still read it) i found the advancedsettings.xml.

I was missing the databasename
So in the <videodatabase> section, I added the line
Code:
<name>xbmcMasterUserDB</name>

rebooted and now it works like a charm.
Reply

Logout Mark Read Team Forum Stats Members Help
Mysql library: mygrating from kodi 14 to 170