Changing from MySQL to MariaDB (1 Viewer)

[Lehmden]

Hi.
You can clear the database used with TVServer when starting SetupTV.exe from a dos prompt with extra arguments:

Command Line Options

Command-line options allow you to specify startup options that are different from the settings currently defined in "MediaPortal Configuration". This allows you to create shortcuts to start MediaPortal with different settings for different users, or to start MediaPortal with one set of options...

www.team-mediaportal.com

 

[Gcarr]

Hi.
You can clear the database used with TVServer when starting SetupTV.exe from a dos prompt with extra arguments:

Command Line Options

Command-line options allow you to specify startup options that are different from the settings currently defined in "MediaPortal Configuration". This allows you to create shortcuts to start MediaPortal with different settings for different users, or to start MediaPortal with one set of options...

www.team-mediaportal.com

Hi Lehmden, Thanks for the reply.
I tried using "/Configure-DB". That allowed me to change the dependency to MariaDB.

The service starts and it shows the correct dependency. And I can start Mediaportal and use it normally

But as soon as I click on the normal TV Configuration shortcut, I get the dependency error again. I select no to not start the service.

TV Config still opens (with values from MariaDB) but the dependency has been reset for TV Server to MySQL56. Weird huh?

 

[Lehmden]

Weird huh?

Jep, especially as TV Server normally runs with MySQL 5.7 too, where you also have no MySQL56... I'm pretty sure this should not happen if all is normal... But now I'm out as I don't use the TV Server. I'm using MP2 where the database engine is SQLite. Much less complicated (no extra database server must be installed) and much faster, but a single user only database engine. Possible for MP2 but not for MP1 as with MP2 the MP2 server is the only user who access the database. In MP1 every client accesses the database so this may not work with SQLite...

 

[Gcarr]

Well, a clean install got me past that database issue but now I'm seeing database deadlocks in the logs during epg importing. Not sure which way I'm going to go now lol.

 

[catavolt]

Did you uninstall MySQL 5.6? That is very important

 

[Gcarr]

Did you uninstall MySQL 5.6? That is very important

Yes, I did. I may try this one more time. What version of MariaDB did you install? Maybe 10.4.15 wasn't a good choice.

 

[catavolt]

I have mariadb-10.5.6-winx64 - working perfect here

 

[Gcarr]

Alright, here I go again then lol.

 

[catavolt]

PS: Just updated to latest mariadb-10.5.7-winx64 without any problems

 

[Gcarr]

PS: Just updated to latest mariadb-10.5.7-winx64 without any problems

Cool, I'll go with that then.