[benyjr]

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.

[wags1]

Have you reviewed the information here?

[benyjr]

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.

[wags1]

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.

[Karellen]

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.

[benyjr]

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.

[benyjr]

Yeah,

I think this is what I will do.

[benyjr]

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.

[benyjr]

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.

[Karellen]

I appreciate you taking the time to offer help.

You are welcome

[wags1]

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.