Comments - Upgrading MariaDB on Windows
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.
Thank you to the maintainers for a trouble-free tool for upgrading databases. Just went from 10.4.8 to 10.5.5. The wizard didn't work for me though, just threw an error that didn't explain the problem (it literally says "Fatal Error" - "mysql_upgrade_service returned error for service [service name]:" and nothing else, then closes when I click OK. Maybe it didn't like the space in the service name?)
By the bye, if you want to be able to back up your MariaDB databases without shutting them down first and without corrupting them, VSS is your friend. Simply flush updates and lock the tables (FLUSH TABLES WITH READ LOCK), create the VSS snapshot, then unlock (UNLOCK TABLES). You can then go in after the fact and copy data to your backup storage. I use this method to refresh my QA and DEVEL instances and it's never given me drama.