Kodi Community Forum
Multiple Devices accessing the Mysql Library - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: General Support (https://forum.kodi.tv/forumdisplay.php?fid=111)
+---- Forum: OS independent / Other (https://forum.kodi.tv/forumdisplay.php?fid=228)
+---- Thread: Multiple Devices accessing the Mysql Library (/showthread.php?tid=342805)



Multiple Devices accessing the Mysql Library - yoda2018 - 2019-04-07

Well ive just installed Debian 9 on my main media center and droped my mysql databases as they was just a test environment to make sure it was working properly.

So th mysql database is populated and everything is set up i juat have one problem.

The xbox one version of kodi is 18.1 and the one from debian is 17.1

do i just adjust the name tag in my advanced settings xml on the xbo to databasename107 as that's the database name in the mysql database


RE: Multiple Devices accessing the Mysql Library - trogggy - 2019-04-07

(2019-04-07, 18:52)yoda2018 Wrote: Well ive just installed Debian 9 on my main media center and droped my mysql databases as they was just a test environment to make sure it was working properly.

So th mysql database is populated and everything is set up i juat have one problem.

The xbox one version of kodi is 18.1 and the one from debian is 17.1

do i just adjust the name tag in my advanced settings xml on the xbo to databasename107 as that's the database name in the mysql database
You can't share mysql databases between different kodi versions.  You'll end up with 2 independent databases on mysql (no shared content / watched status) after setting content and scanning on v17.


RE: Multiple Devices accessing the Mysql Library - yoda2018 - 2019-04-07

(2019-04-07, 19:32)trogggy Wrote:
(2019-04-07, 18:52)yoda2018 Wrote: Well ive just installed Debian 9 on my main media center and droped my mysql databases as they was just a test environment to make sure it was working properly.

So th mysql database is populated and everything is set up i juat have one problem.

The xbox one version of kodi is 18.1 and the one from debian is 17.1

do i just adjust the name tag in my advanced settings xml on the xbo to databasename107 as that's the database name in the mysql database
You can't share mysql databases between different kodi versions.  You'll end up with 2 independent databases on mysql (no shared content / watched status) after setting content and scanning on v17.
ok so how do i go about fixing this?

im assuming if i upgrade the debian distro some how
ill have to re-create the mysql db

could i some how export the database contents and then import them in the new db?


RE: Multiple Devices accessing the Mysql Library - DaVu - 2019-04-07

(2019-04-07, 19:51)yoda2018 Wrote: could i some how export the database contents and then import them in the new db?

https://kodi.wiki/view/Settings/Media/Library#Export_library

Be aware that you have to manually set a tag at the advancedsettings.xml to include the watched state during import:

https://kodi.wiki/view/Advancedsettings.xml#videolibrary

specifically for the watched-state:

xml:

<advancedsettings>
  <videolibrary>
    <importwatchedstate>true</importwatchedstate>
  </videolibrary>
</advancedsettings>



RE: Multiple Devices accessing the Mysql Library - yoda2018 - 2019-04-08

(2019-04-07, 20:10)DaVu Wrote:
(2019-04-07, 19:51)yoda2018 Wrote: could i some how export the database contents and then import them in the new db?

https://kodi.wiki/view/Settings/Media/Library#Export_library

Be aware that you have to manually set a tag at the advancedsettings.xml to include the watched state during import:

https://kodi.wiki/view/Advancedsettings.xml#videolibrary

specifically for the watched-state:

xml:

<advancedsettings>
  <videolibrary>
    <importwatchedstate>true</importwatchedstate>
  </videolibrary>
</advancedsettings>
thanks bro ill keep that to hand for future reference.


Multiple Devices accessing the Mysql Library - yoda2018 - 2019-04-08

Well i lost power during a system update so rather than stick with debian 9 i opted to give debian 10 a push out of the gate.

so ive got debian 10 installed with Kodi 18.

i dropped my previous mysql databases and populated the new database using kodi 18 [emoji4]

just a wrap up question, if and when the next major stable main-line release is out. will i need to use the backup and import method as described above or will it "just work"?


RE: Multiple Devices accessing the Mysql Library - trogggy - 2019-04-08

(2019-04-08, 00:49)yoda2018 Wrote: Well i lost power during a system update so rather than stick with debian 9 i opted to give debian 10 a push out of the gate.

so ive got debian 10 installed with Kodi 18.

i dropped my previous mysql databases and populated the new database using kodi 18 [emoji4]

just a wrap up question, if and when the next major stable main-line release is out. will i need to use the backup and import method as described above or will it "just work"?
It should just work.
Install the update, start it and mysql should make a new database.  Any older versions will carry on using the original.