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.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:ok so how do i go about fixing this?(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.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. 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:
RE: Multiple Devices accessing the Mysql Library - yoda2018 - 2019-04-08 (2019-04-07, 20:10)DaVu Wrote:thanks bro ill keep that to hand for future reference.(2019-04-07, 19:51)yoda2018 Wrote: could i some how export the database contents and then import them in the new db? 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.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. |