How-To Install Mariadb.10.5

[theb2b]

Recently got a request to migrate from VMWare to Proxmox and move VM's over to Proxmox. This has been accomplished but found the VM hosting MariaDB is CentOS 7 leaving no upgrade path. The main application for SQL server is Nextcloud and MariaDB will need to be upgraded from 10.5 to at least l0.6 or better. I have not found a way to update MariaDB on the current VM so I'm looking for some thoughts on how to proceed.

Is it possible to update MariaDB on CentOS then move to a new Debian based VM with MariaDB? If so how to update MariaDB?
Next option install MariaDB 10.5 on a Ubuntu VM then move the DB's to the new VM and began the in-place upgrade to newer version of MariaDB, if so how?

 

[dos2unix]

If it was me....

You can update centOS7 to RockyLinux8. That's not a typo. CentOS to Rocky.
Once it's Rocky8, you can upgrade it to Rocky9.

mariadb 10.5.22 is in the rocky9.x repos. I can give more detailed instructions if you decide to go this path.

 

[dos2unix]

As always, I would backup everything important first.

CentOS 7 End of Life - Migrate to Rocky Linux 9

This article will guide you through the process of migrating your CentOS 7 system to Rocky Linux 9 using the Leapp framework and ELevate repository.

www.tecmint.com

How to Migrate CentOS 7 to Rocky Linux 9 | phoenixNAP KB

This guide demonstrates how to migrate CentOS 7 to Rocky Linux 9 using Leapp and ELevate in a few simple steps.

phoenixnap.com

How to Upgrade from Rocky Linux 8 to 9

This step-by-step guide shows you how to easily upgrade your existing Rocky Linux 8 system to Rocky Linux 9.

linuxiac.com

How to Upgrade from Rocky Linux 8 to Rocky Linux 9 | Vultr Docs

docs.vultr.com

For the most part, it looks like this.

sudo yum install -y elevate-release
sudo yum install -y leapp-upgrade leapp-data-rocky

sudo leapp preupgrade

sudo leapp upgrade

 

[dos2unix]

The other option is to use mariadb-dump to output everything out to a sql file.
Then install a new OS with the version of mariadb you want, and import the dump data
back into mariadb. The danger with this route, if the versions are too far apart, you
may get some import errors, and you might have to tweak a few of the commands.

 

[theb2b]

The other option is to use mariadb-dump to output everything out to a sql file.
Then install a new OS with the version of mariadb you want, and import the dump data
back into mariadb. The danger with this route, if the versions are too far apart, you
may get some import errors, and you might have to tweak a few of the commands.

I tried this solution and MariaDB error and would not let me import it into 10.11, would need to import a compatible file.

Going to give dos2unix solution as a have a full backup of the VM in PBS so feel this is a safe solution. Will need to wait until end of my day tomorrow. Let you all know how it goes.