[Segfault]

It works alright, but I do not want watched state and resume point imported. I tried to set these two to "false" and "no" but they still are read from remote host. What is the correct syntax to store them locally?

Code:

cat .kodi/userdata/advancedsettings.xml 
<advancedsettings>
  <videodatabase>
    <type>mysql</type>
    <host>192.168.2.6</host>
    <port>3306</port>
    <user>kodi</user>
    <pass>kodi</pass>
  </videodatabase> 
  <videolibrary>
    <importwatchedstate>false</importwatchedstate>
    <importresumepoint>false</importresumepoint>
  </videolibrary>
</advancedsettings>

[Klojum]

Code:

  <videolibrary>
    <importwatchedstate>false</importwatchedstate>
    <importresumepoint>false</importresumepoint>
  </videolibrary>


It's possible those settings are only recognized/used when doing a video library export. If you are doing a (re)scraping of your collection with .nfo files containing the watched statuses and resume points, and those are used despite the settings in the AV.xml file, then that would be a bug in my view.

Storing the watched state and resume points separately locally is not supported at this time. If you know how to do SQL queries, removing both data is pretty easy with running just one query.

[Segfault]

I do have two frontends which I want to share this data, that is if I stop watching one I could carry on watching another. And there are two more frontends which should not mess with it, it is most undesirable. You say it is impossible ...
I certainly want to keep the movie data centrally, thousands of movies and lots of erroneous scraping. Over the years these have been corrected manually. I certainly do not want to do it all over again.

[Karellen]

Over the years these have been corrected manually. I certainly do not want to do it all over again.

Then I strongly encourage you to use the Export function of Kodi... https://kodi.wiki/view/Import-export_library

that is if I stop watching one I could carry on watching another

Is this of any use to you, though it requires the original player to still be playing... https://forum.kodi.tv/showthread.php?tid=331325

[Segfault]

Thanks for reminding me the import/export procedure. Anyhow, it solves the issue only partially. When new content is added then in case of central database nothing needs to be done, all frontends will see it as soon as one fetches the info. 
Thus, instead of repeating the whole procedure it would be much easier to log in over SSH and execute a command ... what CLI command can be used to scan new content into database?

[Klojum]

I do have two frontends which I want to share this data, that is if I stop watching one I could carry on watching another. And there are two more frontends which should not mess with it, it is most undesirable. You say it is impossible ...

I'm a bit puzzled. You say you have 2 Kodi clients that use the centralized database for watching videos and share the watched status and resume points. And you have 2 other Kodi clients that use the centralized database that should NOT use the watched status or resume points?? Because that would require you to run two separate databases using the same video source(s). Watch status and resume points cannot be turned off per Kodi client when connected to a MySQL centralized database.

what CLI command can be used to scan new content into database?

See https://forum.kodi.tv/showthread.php?tid=84866 for the 2 methods.

[Segfault]

Thanks. I'm thinking about duplicating that database now. This new client I have is a RPi3, it worked absolutely great with centralized database. Too bad i can't use it, I cannot accept them in living room messing up my watch statuses. I went import/export route. Poor Pi has been importing that database for 2+ hours now. The progress bar has barely moved. I figure it will be done by tomorrow morning perhaps.

[Segfault]

Complete fiasco. Seven hours later the import is still nowhere, maybe 5% done. So I started looking into duplicate database creation and I can't figure that out, either. How can I set up another database? According to Kodi wiki it will be created automatically ... it will not ask me whether I want to name it something different. It is not possible to have two Kodi databases in the same server?

[Klojum]

Complete fiasco. Seven hours later the import is still nowhere, maybe 5% done.

The RPi is not the fastest client for doing imports. Imports also vastly speed up if .nfo files with metadata contents are present next to your movies/tv episodes. Are you using a Wifi connection on the RPi3 or a cabled ethernet connection? Is it a RPi3 or the latest RPi3B+ model? The mSD card write speeds are also a big factor for writing the thumbnails into the local Kodi cache folder. If write speeds of the mSD card are low, then it all takes longer as well.

It is not possible to have two Kodi databases in the same server?

You can have as many databases on your MySQL server as you like, as long as you choose a unique name for it.
You can name the database via the <name> tag. Example:

xml:
<advancedsettings>

  <videodatabase>

    <type>mysql</type>

    <host>192.168.2.6</host>

    <port>3306</port>

    <name>MyVideosTwo</name>

    <user>kodi</user>

    <pass>kodi</pass>

  </videodatabase> 

  <videolibrary>

    <importwatchedstate>false</importwatchedstate>

    <importresumepoint>false</importresumepoint>

  </videolibrary>

</advancedsettings>

which will result in "MyVideosTwo107", as Kodi adds the current version number to your database name.

[Segfault]

Thanks!! That's all I needed to know. i wasn't aware of <name> tag.