[BigMong]

Following the guide just gives me one master database, with different watch status?

I can see in this thread, that this causes a lot of trouble, everytime a new version comes out.

I want 2 independent databases... so I have to scan libraries twice. Everytime I have new content.

But I dont want to start from scratch right now.

I have my MySQL on Synology NAS.

I have tried to copy MyVideos107 to Newuser107
But I dont have "write access" to Newuser107
So I can't mark items as "watched / not watched" or scan for new content.

Yes that's what this does, one mast and slaves.
When using SQL why would you have the data multiple times?
The problems are expected, when the DB number changes it means something in the DB has changed, SQL setups is for Advanced users and the scripts in this thread changes how it works.

If you want 2 DB they run on there own, it looks like your doing it right just missed one step (User permissions).
Keep your advancedsettings.xml on each user with there own <name></name> tags, This points to the Database.

PHP Code:

GRANT ALL PRIVILEGES ON `Kodi\_U01\_Video\_107`.* TO 'KODI_17'@'%' WITH GRANT OPTION; 


Change the above with your setup
Database Name: Kodi\_U01\_Video\_107
if you have _ in it put a \ before
SQL User: KODI_17

Or you can use the lazy way
Please Note: This will give full access to this user account to everything on your SQL Server, Eg. your user is prob KODI with a password of KODI. Security is there for a reason

PHP Code:

GRANT ALL PRIVILEGES ON *.* TO 'KODI_17'@'%' WITH GRANT OPTION; 


More information on GRANT https://dev.mysql.com/doc/refman/5.7/en/grant.html

I hope this answers your question

@john_es
If you rename your old database eg add "_OLD" to the end just so Kodi don't see it,
Follow the 107 Guide

Re-import all your data doing the sync
Then you can run this to update from an older database, one user at a time tho

Awesome!

So, if I rename my old DB to _OLD... and then run the new version of Kodi, it will create me a new blank database... You mentioned to re-import my data - how do I do that? Are we talking about via Kodi interface, or a mysql script?

Yeah if the name changes part from just the number on the end it will create a new database.
Re-import: In Kodi you may already have your sources setup but you will need to reset the type of data (Videos > Files > then press "C" and set type) then it will re-import all data
you can use the other script to copy of your watch status (or you can use Trakt)