Changing from MySQL to MariaDB (1 Viewer)

Gcarr

MP Donator
  • Premium Supporter
  • August 17, 2014
    155
    53
    United States of America United States of America
    Country flag
    From Jira it looks like MP1 will be transitioning to MariaDB in the future so, I've been experimenting a little with this. Not on my actual server but I exported my mptvdb database and then re-imported it into a clean MariaDB mptvdb database. It seems that everything looks good. MySQL Workbench ver 8.0 seems to work fine with it too. I have a new PC coming this week that I'll configure as my new server and I'm thinking to install MP with MariaDB 10.4.15. Are there any issues that I might need to look out for? Is there a good way to do it so that I can revert back to MySQL without any problems? Appreciate any guidance.
     

    azzuro

    Test Group
  • Team MediaPortal
  • May 10, 2007
    9,832
    5,498
    France - IDF
    France France
    Country flag
    From Jira it looks like MP1 will be transitioning to MariaDB in the future so, I've been experimenting a little with this. Not on my actual server but I exported my mptvdb database and then re-imported it into a clean MariaDB mptvdb database. It seems that everything looks good. MySQL Workbench ver 8.0 seems to work fine with it too. I have a new PC coming this week that I'll configure as my new server and I'm thinking to install MP with MariaDB 10.4.15. Are there any issues that I might need to look out for? Is there a good way to do it so that I can revert back to MySQL without any problems? Appreciate any guidance.
    nop i use it since year now, without problem
     

    catavolt

    Design Group Manager
  • Team MediaPortal
  • August 13, 2007
    13,183
    9,474
    Lanzarote
    Germany Germany
    Country flag
    Just asking for some advice:
    To test MariaDB, what steps do I have to do?
    Will it have impact on the DBs like video, pictures etc. ?
    THX in advance ;)
     

    Lehmden

    Retired Team Member
  • Premium Supporter
  • December 17, 2010
    12,260
    3,755
    Lehmden
    Germany Germany
    Country flag
    Hi.
    To test MariaDB, what steps do I have to do?
    You need to uninstall or at least stop TV server then uninstall MySQL. This is necessary as MySQL and MariaDB both are using the same port. Then install MariaDB, install the TVServer or make it to reconfigure the database setup. Now you need to reconfigure the TV setup or re- import the old settings to use the new DB engine. That's all.

    Will it have impact on the DBs like video, pictures etc. ?
    No, not at all. Those are SQlite databases and have nothing to do with the database used by the TV server...
     

    Gcarr

    MP Donator
  • Premium Supporter
  • August 17, 2014
    155
    53
    United States of America United States of America
    Country flag
    Just an update
    I used MySQL Workbench for importing and export the tables... pretty much went like this:

    1. Stop the TVService
    2. Export MySQL table "mptvdb"
    3. Set MySQL service to manual or disabled
    4. Install MariaDB (I used ver. 10.4.15 with the same settings as MySQL, root, password, Port 3306)
    5. Import the previously exported "mptvdb" table

    At this point, I tried to start the TVService but the service had a dependency on MySQL. I had to change it in the registry here:
    [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\TVService]
    Edit "DependOnService" by replacing MySQL with MariaDB (mine actually said MySQL56)

    5. Restarted PC and everything came up fine.

    So, did anyone else run into the dependency issue? @azzuro @Lehmden @catavolt
    I guess if I had uninstalled and reinstalled the TV Server I would have avoided this issue?
     

    catavolt

    Design Group Manager
  • Team MediaPortal
  • August 13, 2007
    13,183
    9,474
    Lanzarote
    Germany Germany
    Country flag
    During the export/import of the TV DB I found that important data aren´t saved and therefore not imported ;)
    Missing important data are all recording/timeshift settings, especially the used folders and the amount and size of timeshift files.
    I think these important data should be part of the export file ;)
    @azzuro Should I open a new thread for this?
     

    Gcarr

    MP Donator
  • Premium Supporter
  • August 17, 2014
    155
    53
    United States of America United States of America
    Country flag
    I also ran into an issue. I can't run TV Configuration because when it starts it looks for the service MySQL56 and in the process of looking, it resets my dependency to MySQL56. I cannot find a way around this part so, I had to revert back for the time being. :(

    I could probably rename the MariaDB service to MySQL56 but that just seems like asking for future trouble.
     

    Users who are viewing this thread

    Similar threads
    OP Title Forum Replies Date
    F MP don't change refresh rate General Support 8
    T Change tv subtitle in MediaPortal 1.26 Newcomers Forum 12
    T Change tv subtitle in MediaPortal 1.26 MediaPortal 1 Talk 0
    Lehmden TVDB will change into a payed service in 2021 OffTopic 10
    toricred MP2 - V2.3 Client Dying When Changing Channels ATSC Submit: Bug Reports 1
    E 1.25.0 Change AVC / AAC Codec for Analog card captured videos Codecs, External Players 0
    C 1.25.0 mini Splashscreen - how can i change it MediaPortal 1 Skins 9
    toricred Recordings Change : to _ in Series Name General 0
    A UK Freeview channel changes Installation, configuration support 14
    T Client / Server slow channel-to-channel change (zapping) General Support 1
    framug [solved] Some changes/fix in MP1 configuration client and server Submit: code patches (MediaPortal/TV-Server/etc.) 14
    catavolt [WiP] When changing theme in my skins, I always get this error message in logs MediaPortal 1 9
    azzuro [WiP] MP1-4999 - Big changes with many related change at once by Sebastiii MediaPortal 1 22
    J How to change y position of subtitles General 3
    D [solved] Changed username in Win10, now TV Server config crashes on fresh install Installation, configuration support 1
    M Change size of the splash screen Skins and Plugins Installer (MPEI) 2
    S Remote button to change audio and subtitle on / off General 10
    BenGonGon chaine qui change aléatoirement Support Général 2
    R [solved] Command / Shortcut for changing subtitles or audio Archive 5
    ge2301 New forum design together with change to XF2.x Online Facilities 4
    doskabouter [Evaluate] Changing SecurityProtocol Developer Discussions 1
    O [Help Me!] How to change 'release' status in Jira? Developer Discussions 9
    cbr954rr [fixed] Movie db refresh on changes of nfo and correct spelling of words in titles 2.2 Archive 33
    KlausWirn Music crash Bass crash no change to play music Installation, configuration support 2
    F Somethings changed - mce remote General Support 9

    Similar threads

    Top Bottom