How to update mariadb?

[sochmal]

SYSTEM INFORMATION
OS type and version	alamalinux 9.5
Webmin version	2.3
Virtualmin version	7.30.4
Webserver version	REQUIRED
Related packages	SUGGESTED

I’m installing moodle on my vps, but it asks me to update mariadb, I have version 10.5.27 and it asks me for at least 10.6.7, I’ve looked for how to do it, I think it can’t be done directly from virtualmin, it should all be done from the console.

Thanks for your guide and help.

[stefan1959]

Read here.

Maria db update

Can you verify which version you are running with this command line? root@main:~# mariadb -V mariadb Ver 15.1 Distrib 10.5.26-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper [image]

Might help

[Steini]

Is it really that hard to use the search button?

Upgrading MariaDB in Virtualmin

You shouldn’t do it at all. But if, here are the steps… Pay attention at every step and don’t do without a current backup! All steps assume you’re logged in as root. Otherwise, prefix with sudo. Perform database backup: mysqldump -u [username] -p[password] [database_name] > backup.sql Stop MariaDB server: systemctl stop mariadb Find the to be installed version number on mariadb.org and pop it in at the end (e. g. 11.2.3): apt install software-properties-common;apt-key adv --fetch-keys 'ht…

This is for Ubuntu. However, if you REALLY know what you do, you can easily modify the commands.

[sochmal]

Thanks I managed to do it with the following tutorial

Upgrading or Updating ... | FileWave KB

[stefan1959]

I used the module method, as long as it works. More then one way to skin a cat.

Looking at my old command I used mariadb-upgrade -u root -p where they use mysql_upgrade -u root -p I presume it does the same thing.

[Steini]

@stefan1959

I presume it does the same thing

mysql_upgrade might still work on some older MariaDB versions, but newer MariaDB versions (10.4 and later) have fully transitioned to mariadb-upgrade. They perform the same function but are specific to their respective database engines.