Comments - Upgrading MariaDB on Windows

I'm at a loss... not a DB master, we are looking to update from 10.0.15 to 10.2.*

Tried the next major step up 10.1.34, Installed the versions side by side but get - "There is no service that can be upgraded to MariaDB 10.1.34"

Where on earth do i go from here?

on earth, you do following: mysql_upgrade_service --service=name_of_your_service.

lol, also tried mysql_upgrade_service --service=name_of_your_service. Says the service doesn't exist.... defiantly running a MariaDB database service and have access via tools like Heidi. Not sure what could be stopping the upgrade service from seeing the service.

There is no message like this with mysql_upgrade_serivice

All service related messages are

• OpenSCManager failed with...
• OpenService failed with...
• QueryServiceConfig failed with...
• Not a valid MySQL service
• Can not downgrade, the service is currently running as version... my version is ...
• ChangeServiceConfig failed with..

Which one is yours ?

C:\Program Files (x86)\MariaDB 10.1\bin>mysql_upgrade_service.exe --service=MariaDbserver Phase 1/8: Changing service configuration FATAL ERROR: Not a valid MySQL service

Even reinstalled the MariaBD database onto another machine from scratch and moved the database across. ODD! Have updated from 10.0.15 to 10.0.36 fine and the service is currently running.

D:\mariadb-10.1.34-win32\bin>mysql_upgrade_service --service=MySQL
Phase 1/8: Changing service configuration
Phase 2/8: Stopping service
Phase 3/8: Starting mysqld for upgrade
Phase 4/8: Waiting for startup to complete
Phase 5/8: Running mysql_upgrade
Phase 6/8: Initiating server shutdown
Phase 7/8: Waiting for shutdown to complete
Phase 8/8: Starting service
Service 'MySQL' successfully upgraded.
Log file is written to C:\Users\wlad\AppData\Local\Temp\mysql_upgrade_service.My
SQL.log

Works for me. Can I suggest to open bug in JIRA in investigate your case, so we do not spam the KB with "bug reports".

C:\Program Files\MariaDB 10.6\bin>mysql_upgrade_service --service=MariaDB Phase 1/10: Stopping service Phase 2/10: Fixing server config file Phase 3/10: Ensuring innodb slow shutdown,this can take some time Phase 4/10: Starting mysqld for upgrade Phase 5/10: Waiting for startup to complete Phase 6/10: Running mysql_upgrade Phase 7/10: Changing service configuration Phase 8/10: Initiating server shutdown Phase 9/10: Waiting for shutdown to complete Phase 10/10: Starting service Service 'MariaDB' successfully upgraded. Log file is written to C:\Users\ADMINI1\AppData\Local\Temp\2\mysql_upgrade_service.MariaDB.log

Works for me.

https://jira.mariadb.org