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

ajs

Development Group
  • Team MediaPortal
  • February 29, 2008
    12,103
    6,883
    Kyiv
    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
    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
    12,103
    6,883
    Kyiv
    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
     

    ajs

    Development Group
  • Team MediaPortal
  • February 29, 2008
    12,103
    6,883
    Kyiv
    Ukraine Ukraine
    Country flag
    @regeszter
    Long lists the contents of the folder with movies about 2-3 times longer.
     

    regeszter

    Retired Team Member
  • Premium Supporter
  • October 29, 2005
    5,335
    4,954
    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
    12,103
    6,883
    Kyiv
    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
    Hungary Hungary
    How many files are in the folder where you see the differencing?
     

    Users Who Are Viewing This Thread (Users: 0, Guests: 1)

    OP Similar threads Forum Replies Date
    toricred Using TMM, How to Stop Importer From Going to The Movie Database for Data General 1
    H MP2 database won't keep in synch with recordings General 8
    F How to reset tv recordings database General 5
    A Synchronizing client databases MediaPortal 1 Talk 10
    R Problems accessing MySQL database remotely MediaPortal 1 Talk 0
    globaldonkey Music Database Error Listen Music 1
    R [solved] Files moved to new location - Easy way to update database? My TVSeries 7
    R Files moved to different location - Easy way to update database? Moving Pictures 2
    H [solved] Video database genres, sort titles and collection thumbnails Newcomers Forum 12
    G MP1 TV Server "failed to upgrade the database" using MS Sql Server Installation, configuration support 3
    D PC rebuild & MP2 upgrade - how to preserve database and settings? General 1
    H MP1.21F video database scan, can it be scheduled to automatically run in background General Support 5
    D Large xml database in My Movies Management. I remain unclear on use My Films as bridge to MP2.2 General 9
    ajs Sync databases by Media Sync Service MediaPortal 1 Talk 26
    J Database schema General 0
    W [solved] MP 1.20 Video IMDB no showing plot General Support 129
    hounddog How to get My Films working in MP 1.20 My Films 5
    C How well can MediaPortal handle 10,000+ recordings? MediaPortal 1 Talk 3
    H Database migration Archive 85
    D Single Seat Install - can another single seat use the same databases? Installation, configuration support 1
    P [Resolved] Missing column in database My TVSeries 7
    M Need advice on writing plugin that modifies EPG database TV-Server 2
    Rob Hexenmeister Skinning Online Videos question OnlineVideos 2
    A [solved] How to Play All Videos in a List watch/edit Videos 3
    O 1.25.0 Codecs and Video Format for PlayStation 2 Codecs, External Players 0
    Similar threads

























    Top Bottom