Comments - Upgrading MariaDB on Windows

5 years, 7 months ago Peter Deacon

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?

 
5 years, 7 months ago Vladislav Vaintroub

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

 
5 years, 7 months ago Peter Deacon

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.

 
5 years, 7 months ago Vladislav Vaintroub

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 ?

 
5 years, 7 months ago Peter Deacon

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.

 
5 years, 7 months ago Vladislav Vaintroub
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".

 
2 years, 8 months ago Reinaldo Moreno

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.

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.