Hello all,
I need some help with setting up a MySQL db.
I’ve read the wiki but I can’t figure out what I’m missing.
I have a main PC running W7 which is my NAS (192.168.1.127).
I have a NUC running W10 Krypton RC3 and I have a ODroid C2 running Krypton RC2, as well.
I’ve d/led and installed version 5.5.42. on the main PC.
I’ve added a advancedsettings.xml in both boxes:
<advancedsettings>
<videodatabase>
<type>mysql</type>
<host>192.168.1.127</host>
<port>3306</port>
<user>kodi</user>
<pass>kodi</pass>
</videodatabase>
<video>
</video>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
<importresumepoint>true</importresumepoint>
</videolibrary>
</advancedsettings>I exported my library to multiple files from my NUC (which previously had all my non MySQL videos from NFS).
I then added new Sources on the ODroid C2.
Both boxes show a MyVideos107.db
However if I watch something on one box it’s not being marked as watched on the other one.
When I look at one of my video’s path I still see: NFS share/letter of the drive on my NAS.
Should I be seeing something different?
Also, how do I access the db on the main PC? Looking in the C:/ drive all I see is a MySQL Server 5.5 but I don’t see an application that can be opened…
Sorry for all the questions but it’s really confusing to me 