MySQL Database: Multiple XBMC HTPC's with 1 Shared 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: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library (/showthread.php?tid=85654) |
RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - hermy65 - 2015-01-10 (2015-01-10, 20:48)nickr Wrote:(2015-01-10, 17:48)hermy65 Wrote:I assumed you had different sources set up for the two computers and were scraping on each one.(2015-01-10, 00:59)nickr Wrote: On your adult computer use VideosAdult and on the kids use VideosKids. Or whatever names you prefer. I have two clients, 1 has everything on it and the other only has kids stuff on it RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - nickr - 2015-01-10 And you want each to have an independent database on mysql right? So give each a separate name. I can't figure which bit is giving you problems. RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - judocama - 2015-01-10 (2015-01-10, 22:33)nickr Wrote:(2015-01-10, 22:29)judocama Wrote:The exact path from the database please.(2015-01-09, 21:47)nickr Wrote: So in your database, what is the path to one of these posters? Yosemite/Usuarios/JuanDo/Libreria/Application Support/Kodi/ This is the directory in my local Mac where I have also running mysql. An This directory also I have shared vía nfs Manager in my network Thanks in advance RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - nickr - 2015-01-10 no I asked for you to look IN the database and tell me the path that the database records for a piece of artwork. RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - hermy65 - 2015-01-11 (2015-01-10, 23:25)nickr Wrote: And you want each to have an independent database on mysql right? So give each a separate name. I can't figure which bit is giving you problems. I can surely make 2 separate databases. My initial question was asking if i could do it all through one database. RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - nickr - 2015-01-11 (2015-01-11, 02:05)hermy65 Wrote:In that case I completely misunderstood your question. Sorry about that. I thought you were trying to put your two databases on one server.(2015-01-10, 23:25)nickr Wrote: And you want each to have an independent database on mysql right? So give each a separate name. I can't figure which bit is giving you problems. RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - hermy65 - 2015-01-11 (2015-01-11, 03:09)nickr Wrote:(2015-01-11, 02:05)hermy65 Wrote:In that case I completely misunderstood your question. Sorry about that. I thought you were trying to put your two databases on one server.(2015-01-10, 23:25)nickr Wrote: And you want each to have an independent database on mysql right? So give each a separate name. I can't figure which bit is giving you problems. Not a problem. So back to my original question, is it possible to make my current setup work using mysql? RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - nickr - 2015-01-11 It is possible to make it work with MySQL in exactly the way I have already described with separate databases for each client. The way to create separate databases is to use the <name> parameter. RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - D-an-W - 2015-01-11 Morning folks, I think I might have fumbled my way through the setup and even got it working but is there a way to check this with only one of my clients running at the moment (New kitchen & decorating is spoiling my fun!)? Could I use something like Sequel Pro to check the database stored on the server or what files are created by MySQL when its actually working correctly? RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - nickr - 2015-01-11 yes, a relevant table to query is movie in database MyVideosNN (where NN is dependent on what version ox XBMC/KODI you are running. movie contains your movie info. Code: SELECT c00 FROM movie; Whether you do this from the commandline, or from some gui should be immaterial. RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - judocama - 2015-01-11 (2015-01-10, 23:47)nickr Wrote: no I asked for you to look IN the database and tell me the path that the database records for a piece of artwork. Sorry, just realized this computer because if you saw the pictures. It was because when I made the disc scrapper had not modified the advancesettings and I recorded the images locally and mysql at a time. RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - RamboUnchained - 2015-02-20 5 years and not a single person has done a tutorial actually worth watching...I dont get it. There are Kodi/XBMC tuts out there that explain how to do things a monkey could learn to do, but there's no solid tut for this. I'm used to working with hardware and software that TELLS me if I've done something right or wrong. Following text tutorials has lead me nowhere. And when you ask for help, people assume you're on Linux...Please...Someone take 15min of your time and make a true step by step guide to this for Windows as well. Linux tuts are of no use to me since the commands seem to be completely different. A 15min video stickied on the forums would save a lot of people a lot of time. RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - Netix - 2015-02-20 Hi guys, don't know where to post this but it seems when my remote chromebox update his library the MYSQL is rescanning every path even if there's no change to it. This does take a long time, 3min41 for a library update. Here's my pastebin : http://goo.gl/oWV2M5 RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - nickr - 2015-02-20 (2015-02-20, 15:47)RamboUnchained Wrote: 5 years and not a single person has done a tutorial actually worth watching...I dont get it. There are Kodi/XBMC tuts out there that explain how to do things a monkey could learn to do, but there's no solid tut for this. I'm used to working with hardware and software that TELLS me if I've done something right or wrong. Following text tutorials has lead me nowhere.Is the process not fully described, for windows, here? http://kodi.wiki/view/MySQL/Setting_up_MySQL#tab=Windows RE: MySQL Database: Multiple XBMC HTPC's with 1 Shared Library - Tight_wad - 2015-02-20 How to search, it's easy Click the link, you will have your video |