[WiP] Centralised database in My Video, My Pictures and folder settings (1 Viewer)

ajs

Development Group
  • Team MediaPortal
  • February 29, 2008
    13,750
    8,298
    Kyiv
    Home Country
    Ukraine Ukraine
    Country flag
    You can try it. The installer is attached to the 1st post.
    What is the difference from the previous one? Added a username and password? Changes in the configuration?

    I still can not make up my mind to go to this version, due to the fact that I have to clean fanarthandler database.
     

    regeszter

    Retired Team Member
  • Premium Supporter
  • October 29, 2005
    5,335
    4,954
    Home Country
    Hungary Hungary
    What is the difference from the previous one?

    The old one was based on MP 1.10 Final, the new one based one 1.11 Pre Release.

    Added a username and password?

    Yes. Please read the 1st post. ;)

    Code:
      <section name="mpdatabase">
        <entry name="hostname">localhost</entry>
        <entry name="username">root</entry>
        <entry name="password">MediaPortal</entry>
      </section>
     

    ajs

    Development Group
  • Team MediaPortal
  • February 29, 2008
    13,750
    8,298
    Kyiv
    Home Country
    Ukraine Ukraine
    Country flag
    Yes. Please read the 1st post
    :whistle: Oh, went to read :D


    <entry name="username">root</entry>
    If another user is, what the right cut? Same as in Kodi?
    Code:
    Enter the following commands:
    * Type in: CREATE USER 'mediaportal' IDENTIFIED BY 'mediaportal'; and press return
    * Type in: GRANT ALL ON *.* TO 'mediaportal'; and press return
     

    regeszter

    Retired Team Member
  • Premium Supporter
  • October 29, 2005
    5,335
    4,954
    Home Country
    Hungary Hungary
    @regeszter
    Long lists the contents of the folder with movies about 2-3 times longer.
    Yes, a service based database is slower than a file based like sqlite but there are many advantage. You can access, write(!) same tables at same time from clients without database corruption. The database server will handle the lock.

    You may go back the sqlite database and try a plugin based syncronisation.

    But I do not know if they can handle if you will use more than one client at same time.
     

    ajs

    Development Group
  • Team MediaPortal
  • February 29, 2008
    13,750
    8,298
    Kyiv
    Home Country
    Ukraine Ukraine
    Country flag
    Yes, a service based database is slower than a file based like sqlite but there are many advantage.
    Interestingly though, Kodi access MySQL database on faster than locally, but not much faster. At least Raspberry Pi. He is there comparable to the speed of the media portal with a local database.
     

    regeszter

    Retired Team Member
  • Premium Supporter
  • October 29, 2005
    5,335
    4,954
    Home Country
    Hungary Hungary
    How many files are in the folder where you see the differencing?
     

    Users who are viewing this thread

    Similar threads

    This is not possible if it is a self made series, like personal travel videos etc.
    This is not possible if it is a self made series, like personal travel videos etc.
    Hi! I have videos that I want to show in TV-Series, such as personal TV series and educational series. As some examples I have...
    Replies
    8
    Views
    426
    We are proud to present MediaPortal 2.3.1 MediaPortal 2.3.1 is a full-blown media center software that addresses the most common user requirements out of the box. Aside from its support for Live TV and Radio, it offers a complete media server for music, movies, and TV shows. Info is automatically downloaded from various sources to...
    We are proud to present MediaPortal 2.3.1 MediaPortal 2.3.1 is a full-blown media center software that addresses the most common...
    We are proud to present MediaPortal 2.3.1 MediaPortal 2.3.1 is a full-blown media center software that addresses the most common...
    Replies
    0
    Views
    767
    It is looking and working very well now and I am almost at the point of switching my HTPC to MP2, madvr would definitely push me over the edge for sure.;)
    It is looking and working very well now and I am almost at the point of switching my HTPC to MP2, madvr would definitely push me...
    We are proud to present MediaPortal 2.3 MediaPortal 2.3 is a full-blown media center software that addresses the most common user...
    Replies
    4
    Views
    2K
    We are proud to present MediaPortal 2.2.2 MediaPortal 2.2.2 is a full-blown media center software that addresses the most common user requirements out of the box. Besides its TV and Radio services it is also offering a complete media management for movies, series and music, including posters, album and fan art as well as additional...
    We are proud to present MediaPortal 2.2.2 MediaPortal 2.2.2 is a full-blown media center software that addresses the most common...
    We are proud to present MediaPortal 2.2.2 MediaPortal 2.2.2 is a full-blown media center software that addresses the most common...
    Replies
    0
    Views
    2K
    Sad to see you replied so late, I've long since moved from 32bit to 64bit, so you've gone through all that trouble to help me for nothing. Thanks anyway. Emph
    Sad to see you replied so late, I've long since moved from 32bit to 64bit, so you've gone through all that trouble to help me for...
    ************************************************* EDIT 2019-04-29: New version, see Gitlad for change log. Thank you SINCowboy So...
    Replies
    25
    Views
    8K
    Top Bottom