+- 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: SQL Database for v20 readable for v17? (/showthread.php?tid=374031)
SQL Database for v20 readable for v17? - Tiraga - 2023-08-06
Hi, i got two HTPC running Kodi 17.7 DSPlayer x64 (2020 build) with a MySQL Database and got a NVIDIA Shield with the newest Kodi 20 Build i want to add. Would it be possible to upgrade the SQL Database to Version 20 and let the 17.7 Kodi Versions read from it or do i need to use something like Emby or Jellyfin to get this Versions to work together?
RE: SQL Database for v20 readable for v17? - jbinkley60 - 2023-08-06
(2023-08-06, 11:46)Tiraga Wrote: Hi, i got two HTPC running Kodi 17.7 DSPlayer x64 (2020 build) with a MySQL Database and got a NVIDIA Shield with the newest Kodi 20 Build i want to add. Would it be possible to upgrade the SQL Database to Version 20 and let the 17.7 Kodi Versions read from it or do i need to use something like Emby or Jellyfin to get this Versions to work together?
Mezzmo and the Mezzmo Kodi addon fully support running different versions of Kodi at the same time with 100% feature parity and information sharing across Kodi / non-Kodi devices, along with seamless upgrades / downgrades. I have 4 different versions of Kodi running with Mezzmo right now. From my understanding of MySQL you can run different versions at the same time but they can't share data since the database names are different. In my setup, the Mezzmo Kodi addon handles any differences between database names, versions and schemas. I can't speak for Emby or Jellyfin.
Note that version 1.1.8.1 is the last official version of the Mezzmo Kodi addon to support Kodi 17 but I can easily make you a version of the latest 1.1.9.2 code with Kodi 17 support. It's 2 lines of code to add back.
Thanks,
Jeff
RE: SQL Database for v20 readable for v17? - scott967 - 2023-08-07
When db versions change it means the schemas for the tables/columns have changed so queries to a "wrong" version will probably fail even if you just rename the database.
scott s.
.
RE: SQL Database for v20 readable for v17? - Tiraga - 2023-08-18
Sorry for the late answer I can't login to my account with firefox anymore and have no idea, I needed to install another browser to get in.
Thanks for the tip I'll take a look at it.