Resolved Upgrading MariaDB on New AlmaLinux Server

[Robin McDermott]

Server operating system version

AlmaLinux 9.5

Plesk version and microupdate number

Plesk Obsidian 18.0.65 Update #2

Hello, I am moving from:

Plesk Obsidian 18.0.64 Update #1 CentOS Linux 7.9.2009 (Core) running MariaDB 10.5.26

TO

Plesk Obsidian 18.0.65 Update #2AlmaLinux 9.5 (Teal Serval) running MariaDB 10.5.22

I am unable to move any of my wordpress sites because the MariaDB version on the OLD server is newer than the version on the NEW Server. My hosting provider, Aptum, is telling me that there is NOT an upgrade available for MariaDB for the new server or it would be upgraded.

Really? How could the old server have upgraded to a new version of MariaDB if it isn't available?

Is there some sort of workaround? I have tried manually dumping and moving the DBs - that doesn't work. What I really need is a way to update MariaDB on my new server and am happy to do a manual update if necessary.

 

[Raul A.]

Upgrade to MariaDB 10.6 on the new server. It is the longest supported MariaDB version.

 

[Robin McDermott]

OK thanks for that info, but how do I do that if an upgrade for MariaDB isn't available in the Plesk Interface on the new server?

 

[Raul A.]

This should help you. However, I always upgraded via SSH. Add the desired MariaDB repository, yum update Maria DB*, then MYSQL_PWD="$(cat /etc/psa/.psa.shadow)" && mysql_upgrade -uadmin

 

[Robin McDermott]

Thanks for the additional insight, but where do I actually get the upgraded version to install?

 

[Raul A.]

MariaDB Package Repository Setup and Usage

Executing and using a convenient shell script to set up the MariaDB Package Repository.

mariadb.com

curl -LsS https://r.mariadb.com/downloads/mariadb_repo_setup | sudo bash -s -- --mariadb-server-version=mariadb-10.6 --skip-maxscale

 

[Kaspar]

@Robin McDermott, there is an Plesk support article available detailing how to manually upgrade MariaDB on your Plesk server. See: https://support.plesk.com/hc/en-us/...-5-to-5-6-5-7-or-MariaDB-5-5-to-10-x-on-Linux

Note that the article has two "tabs" outlining different methodes to upgrade MariaDB. Click the "Manual procedure" to view the manual Steps to upgrade MariaDB.

 

[Robin McDermott]

Thank you for this help. I ended up having our server hosts handle the DB migration.