[yoda2018]

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

[trogggy]

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.

[yoda2018]

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?

[DaVu]

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

https://kodi.wiki/view/Settings/Media/Li...rt_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....deolibrary

specifically for the watched-state:

xml:


<advancedsettings>

  <videolibrary>

    <importwatchedstate>true</importwatchedstate>

  </videolibrary>

</advancedsettings>

[yoda2018]

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

https://kodi.wiki/view/Settings/Media/Li...rt_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....deolibrary

specifically for the watched-state:

xml:


<advancedsettings>

  <videolibrary>

    <importwatchedstate>true</importwatchedstate>

  </videolibrary>

</advancedsettings>

thanks bro ill keep that to hand for future reference.

[yoda2018]

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"?

[trogggy]

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.