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

ajs

Development Group
  • Team MediaPortal
  • February 29, 2008
    12,446
    7,140
    Kyiv
    Ukraine Ukraine
    Country flag
    You may install a stand alone TvServer to the host which will be installed with right setup. You can uninstall it later.
    I can not do that. I do not like to put too much. I've already figured out myself.

    Add localnet acess permition for root, But it is bad, it is necessary to urgently make the setting for a user name and password.:D
    ... on MySQL only picturedatabase and videodatabase. :coffee:
    Launched import NFO files.
    upload_2015-2-13_21-20-29.png upload_2015-2-13_21-25-43.png

    Log imports 509 files in attachment. Very long import ... :( ~50 min for ~500 nfo files ...
    upload_2015-2-13_22-11-25.png upload_2015-2-13_22-11-42.png
     

    regeszter

    Retired Team Member
  • Premium Supporter
  • October 29, 2005
    5,335
    4,954
    Hungary Hungary
    Log imports 509 files in attachment. Very long import ... :( ~50 min for ~500 nfo files ...

    Can you compare (do the same import in a clean database) in SQLite database too?

    What is your experiment with this feature? ;)
     

    regeszter

    Retired Team Member
  • Premium Supporter
  • October 29, 2005
    5,335
    4,954
    Hungary Hungary
    I'll try, but exports only took a couple of minutes.
    We scan the files by mediainfo.dll to get the resolution, audio and video codec info, so the import is longer than export.

    regeszter said: ↑
    What is your experiment with this feature?
    Do not quite understand what you mean.
    Did you test it inside the MP GUI to see how it works (performance, watched status, etc) or tested it with more than one client using with same database (without database corruption).
     

    ajs

    Development Group
  • Team MediaPortal
  • February 29, 2008
    12,446
    7,140
    Kyiv
    Ukraine Ukraine
    Country flag
    Did you test it inside the MP GUI to see how it works (performance, watched status, etc) or tested it with more than one client using with same database (without database corruption).
    Unfortunately I can not move all the HTPC on MySQL, while I can only check one en.

    We scan the files by mediainfo.dll to get the resolution, audio and video codec info, so the import is longer than export.
    Then most likely speed will be the same ...
     

    ajs

    Development Group
  • Team MediaPortal
  • February 29, 2008
    12,446
    7,140
    Kyiv
    Ukraine Ukraine
    Country flag
    IMHO it is necessary to make settings such settings Kodi.
    XML:
      <videodatabase>
        <type>mysql</type>
        <host>***.***.***.***</host>
        <port>3306</port>
        <user>MediaPortal</user>
        <pass>MediaPortal</pass>
      </videodatabase>
      <musicdatabase>
        <type>mysql</type>
        <host>***.***.***.***</host>
        <port>3306</port>
        <user>MediaPortal</user>
        <pass>MediaPortal</pass>
      </musicdatabase>
     

    regeszter

    Retired Team Member
  • Premium Supporter
  • October 29, 2005
    5,335
    4,954
    Hungary Hungary
    IMHO it is necessary to make settings such settings Kodi.
    Yes but I do not think we should to use different server for each databases. One is enough.

    I updated the installer. It is based on 1.11 Pre Release.
     

    ajs

    Development Group
  • Team MediaPortal
  • February 29, 2008
    12,446
    7,140
    Kyiv
    Ukraine Ukraine
    Country flag
    Yes but I do not think we should to use different server for each databases. One is enough.
    Until enough for one, but there time will tell, it is necessary to someone more servers or not.

    I updated the installer. It is based on 1.11 Pre Release.
    Changes to the database have? Music is added or not?
     

    regeszter

    Retired Team Member
  • Premium Supporter
  • October 29, 2005
    5,335
    4,954
    Hungary Hungary
    Until enough for one, but there time will tell, it is necessary to someone more servers or not.
    You can try it. The installer is attached to the 1st post.

    Changes to the database have? Music is added or not?
    The music database is under construction by @hwahrmann . I can not add MySQL support until he is not finished it.
     

    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
    N [not reproducible] Online videos not working at all Submit: Bug Reports 1
    R Bug: Video Folders disappear General Support 11
    Stephen O'Kane [SOLVED] TV Stream stuttering - both Video and Audio Watch / Listen Media 14
    B some music videos stutter Watch / Listen Media 0
    Similar threads

























    Top Bottom