Changing from MySQL to MariaDB (1 Viewer)

Gcarr

MP Donator
  • Premium Supporter
  • August 17, 2014
    192
    68
    Home Country
    United States of America United States of America
    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,891
    5,551
    France - IDF
    Home Country
    France France
    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,658
    9,857
    Königstein (Taunus)
    Home Country
    Germany Germany
    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,415
    3,860
    Lehmden
    Home Country
    Germany Germany
    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
    192
    68
    Home Country
    United States of America United States of America
    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,658
    9,857
    Königstein (Taunus)
    Home Country
    Germany Germany
    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
    192
    68
    Home Country
    United States of America United States of America
    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

    @Andy_2639 : I regret to say that I don't think that this problem will be fixed. :( As the years pass, the number of active members of the MP team steadily decreases, and as far as I know, there is no one in the current team who knows much about either SQL or TV Server. The problem will remain unfixed until someone who knows SQL...
    @Andy_2639 : I regret to say that I don't think that this problem will be fixed. :( As the years pass, the number of active...
    I updated my MySQL server from 8.0.28 to 8.0.29 and now the tvservice crashes on start. The attached log doesn't give me a clue...
    Replies
    6
    Views
    576
    I don't think it can be done that much easier. If you're not comfortable doing these kinds of things on your computer, you'd better leave it to a more eperienced person...
    I don't think it can be done that much easier. If you're not comfortable doing these kinds of things on your computer, you'd better...
    Hi I have been using MediaPortal 1.2.3.0 for years and it has been working well. However, today I receive the message "Connection...
    Replies
    15
    Views
    884
    Hi, must be really a while, cuz I can not remember any post from you ;) But might be also that I joined the team too late. Yes, there will be many things. Main reason is simply, that MP2 is not developed based on MP1. I for example never used MP1. I tried it lately to test voice control and was shocked about many inconsistancies in...
    Hi, must be really a while, cuz I can not remember any post from you ;) But might be also that I joined the team too late. Yes...
    It´s been a while... :) Well, simply the reason is cause MP1 was working so well... :) Now I decided to upgrade my old servers and...
    Replies
    1
    Views
    967
    Previous posts not related to this thread have been moved here
    Previous posts not related to this thread have been moved here
    While we are chatting, now get mad, you know that I said I would refactor the database to get rid of any redundancies. I've done...
    Replies
    396
    Views
    16K
    For me it crashed when checked and when unchecked, it played with audio over HDMI. And this, with latest Intel drivers.
    For me it crashed when checked and when unchecked, it played with audio over HDMI. And this, with latest Intel drivers.
    Can someone please take a look at the attached logs. This is driving me insane! I have MadVr and LAV set up on same computer in...
    Replies
    15
    Views
    1K
    Top Bottom