+- 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: can you spare me a moment of your time (/showthread.php?tid=341452)
can you spare me a moment of your time - yoda2018 - 2019-02-28
im setting up a mysql server to interface with kodi for libary sync etc.
my question is this if for whatever reason the mysql server goes down is there an option to fall back to a local library ?
any help you can give me is most appreciated
ATB, Yoda
RE: can you spare me a moment of your time - Klojum - 2019-02-28
Kodi should fall back to the local database, but only after a lengthy timeout should MySQL be unavailable. The local and mysql databases will also likely have vastly different contents. So I'm not sure if having SQLite as a fallback/backup is all that realistic.
RE: can you spare me a moment of your time - yoda2018 - 2019-03-01
(2019-02-28, 23:42)Klojum Wrote: Kodi should fall back to the local database, but only after a lengthy timeout should MySQL be unavailable. The local and mysql databases will also likely have vastly different contents. So I'm not sure if having SQLite as a fallback/backup is all that realistic.thanks Klojum my plan is this.
use the mysql database as my primary media library.
if the my sql server goes offline for any reason kodi should revert to its own internal library if im correct.
RE: can you spare me a moment of your time - Karellen - 2019-03-01
(2019-03-01, 00:52)yoda2018 Wrote: if the my sql server goes offline for any reason kodi should revert to its own internal library if im correct.It depends on what you are expecting to happen.
If you are expecting that MySQL becomes unavailable, yet still be able to see and navigate your library (as you had setup in MySQL) that won't happen. You will most likely see an empty library, or whatever you had in the local SQL databases before you converted to MySQL. The two databases are mutually exclusive.
RE: can you spare me a moment of your time - Klojum - 2019-03-01
In other words: if you are using a MySQL database, the local SQLite database is not being automatically synced with the MySQL database. Or vice versa. As always you are yourself responsible for the 100& workings of your MySQL setup as well as backups of your data in case disaster strikes.
can you spare me a moment of your time - yoda2018 - 2019-03-01
thanks guys thats what i wanted to know it, that's what i thought would happen glad to know kodi wouldn't just break and stop working