Information - When using Kodi with MariaDB, where are the databases?

Information When using Kodi with MariaDB, where are the databases? - 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: Linux (https://forum.kodi.tv/forumdisplay.php?fid=52)
+---- Thread: Information When using Kodi with MariaDB, where are the databases? (/showthread.php?tid=377608)

When using Kodi with MariaDB, where are the databases? - benyjr - 2024-05-20

I have Kodi 21 installed via flatpack on Ubuntu 24.04. The database is shared with a Kodi 21 install on my Nvidia Shield as per the official Kodi instructions. It's all working well.

I just have one question.

Are the active databases stored here:

/var/lib/mysql

or here:

/home/<user>/.var/app/tv.kodi.Kodi/data/userdata/Database

I absolutely cannot find this answer. There are Kodi databases in both locations.

RE: When using Kodi with MariaDB, where are the databases? - wags1 - 2024-05-20

Have you reviewed the information here?

RE: When using Kodi with MariaDB, where are the databases? - benyjr - 2024-05-20

I did follow these instructions for setting up MariaDB with Kodi and it did work perfectly.

I could not find the answer to my question however.

RE: When using Kodi with MariaDB, where are the databases? - wags1 - 2024-05-20

Not sure I understand exactly what you did. The reason to use an external DB (in this specific MariaDB) is so that you can share your library DB(s) between multiple instances of Kodi. If done correctly you should have your DB(s) shared not duplicated on each device running Kodi. For example in my case I have my DBs on my Synology NAS and all my devices that run Kodi access the library DBs there. They don’t have separate DBs.

RE: When using Kodi with MariaDB, where are the databases? - Karellen - 2024-05-20

(2024-05-20, 12:44)benyjr Wrote: Are the active databases stored here:

I don't use MySQL, but from a process of elimination, it would not be in data/userdata/Database as this is the local sql database.
Simple to check. Open the database in both locations and see what is inside and which is current.

RE: When using Kodi with MariaDB, where are the databases? - benyjr - 2024-05-20

I agree. Just based on the file revision date, the computer where MariaDB is installed, is using the local database.

Though the shield is still displaying an up to date library without having to force a scan.

It's weird.

RE: When using Kodi with MariaDB, where are the databases? - benyjr - 2024-05-21

Yeah,

I think this is what I will do.

RE: When using Kodi with MariaDB, where are the databases? - benyjr - 2024-05-21

(2024-05-20, 21:55)wags1 Wrote: Not sure I understand exactly what you did. The reason to use an external DB (in this specific MariaDB) is so that you can share your library DB(s) between multiple instances of Kodi. If done correctly you should have your DB(s) shared not duplicated on each device running Kodi. For example in my case I have my DBs on my Synology NAS and all my devices that run Kodi access the library DBs there. They don’t have separate DBs.

So I clearly misunderstood what I was looking at in /var/lib/mysql.

MyVideos131 and such are not databases themselves but folders, which explains why the modified dates aren's updating.

Inside this folder, various files were modified yesterday, which is the last time new shows were added.

I appreciate your response and your help. Thank you for taking the time to respond.

RE: When using Kodi with MariaDB, where are the databases? - benyjr - 2024-05-21

(2024-05-20, 22:07)Karellen Wrote:
(2024-05-20, 12:44)benyjr Wrote: Are the active databases stored here:
I don't use MySQL, but from a process of elimination, it would not be in data/userdata/Database as this is the local sql database.
Simple to check. Open the database in both locations and see what is inside and which is current.

You were correct. They were in /var/lib/mysql. I just didnt understand what I was looking at when I listed the contents of this folder, but I have figured it out now.

I appreciate you taking the time to offer help.

RE: When using Kodi with MariaDB, where are the databases? - Karellen - 2024-05-21

(2024-05-21, 02:50)benyjr Wrote: I appreciate you taking the time to offer help.

You are welcome Smile

RE: When using Kodi with MariaDB, where are the databases? - wags1 - 2024-05-21

(2024-05-21, 02:43)benyjr Wrote:
(2024-05-20, 21:55)wags1 Wrote: Not sure I understand exactly what you did. The reason to use an external DB (in this specific MariaDB) is so that you can share your library DB(s) between multiple instances of Kodi. If done correctly you should have your DB(s) shared not duplicated on each device running Kodi. For example in my case I have my DBs on my Synology NAS and all my devices that run Kodi access the library DBs there. They don’t have separate DBs.

So I clearly misunderstood what I was looking at in /var/lib/mysql.

MyVideos131 and such are not databases themselves but folders, which explains why the modified dates aren's updating.

Inside this folder, various files were modified yesterday, which is the last time new shows were added.

I appreciate your response and your help. Thank you for taking the time to respond.

YW…glad you got it sorted.