MARIADB10.4.0 to 10.10.0

Will this method still work to go from 10.4 to 10.10?

https://wiki.centos-webpanel.com/mariadb-upgrade-from-10-2-to-10-4

Yes. The instructions are still valid with minor changes. You just need to change the line:

Code: [Select]

sed -i 's/10.2/10.4/g' /etc/yum.repos.d/mariadb.repo
Use the current MariaDB version installed on your server as the first argument and the new MariaDB version as the second argument.

It looks like it's still trying to install 10.4 anyway after doing those commands on that page. I can't install laravel without incresing to 10.10

[root@viking ~]# mysql -V
mysql  Ver 15.1 Distrib 10.4.34-MariaDB, for Linux (x86_64) using readline 5.1
[root@viking ~]# cat /etc/redhat-release
AlmaLinux release 8.10 (Cerulean Leopard)
[root@viking ~]# mysqldump –all-databases > /tmp/all-database-backup.sql
mysqldump: Got error: 1049: "Unknown database '–all-databases'" when selecting the database
[root@viking ~]# rpm -qa|grep -i maria|grep "\-10.4."
MariaDB-devel-10.4.34-1.el8.x86_64
MariaDB-common-10.4.34-1.el8.x86_64
MariaDB-client-10.4.34-1.el8.x86_64
MariaDB-server-10.4.34-1.el8.x86_64
MariaDB-shared-10.4.34-1.el8.x86_64
[root@viking ~]# sed -i 's/10.4/10.10/g' /etc/yum.repos.d/mariadb.repo
[root@viking ~]# systemctl stop mariadb mysql mysqld
[root@viking ~]# systemctl disable mariadb
Removed /etc/systemd/system/multi-user.target.wants/mariadb.service.
Removed /etc/systemd/system/mysql.service.
Removed /etc/systemd/system/mysqld.service.
[root@viking ~]# rpm --nodeps -ev MariaDB-server
Preparing packages...
MariaDB-server-10.4.34-1.el8.x86_64
[root@viking ~]# yum clean all
81 files removed
[root@viking ~]# yum -y update "MariaDB-*"
CentOS Web Panel repo for Linux 8 - x86_64                                                                                                                  1.7 MB/s | 305 kB     00:00
AlmaLinux 8 - BaseOS                                                                                                                                         13 MB/s | 7.4 MB     00:00
AlmaLinux 8 - AppStream                                                                                                                                      19 MB/s |  13 MB     00:00
AlmaLinux 8 - Extras                                                                                                                                         31 kB/s |  13 kB     00:00
AlmaLinux 8 - PowerTools                                                                                                                                    7.0 MB/s | 3.7 MB     00:00
AlmaLinux 8 - PowerTools Source                                                                                                                             108 kB/s | 138 kB     00:01
AlmaLinux 8 - PowerTools debuginfo                                                                                                                          666 kB/s | 610 kB     00:00
Extra Packages for Enterprise Linux 8 - x86_64                                                                                                               22 MB/s |  14 MB     00:00
MariaDB                                                                                                                                                      52  B/s |  10  B     00:00
Errors during downloading metadata for repository 'mariadb':
  - Status code: 404 for http://mirror.mariadb.org/yum/10.10/centos8-amd64/repodata/repomd.xml (IP: 162.55.42.214)
Error: Failed to download metadata for repo 'mariadb': Cannot download repomd.xml: Cannot download repodata/repomd.xml: All mirrors were tried
[root@viking ~]# yum -y install MariaDB-server
MariaDB                                                                                                                                                      53  B/s |  10  B     00:00
Errors during downloading metadata for repository 'mariadb':
  - Status code: 404 for http://mirror.mariadb.org/yum/10.10/centos8-amd64/repodata/repomd.xml (IP: 162.55.42.214)
Error: Failed to download metadata for repo 'mariadb': Cannot download repomd.xml: Cannot download repodata/repomd.xml: All mirrors were tried
[root@viking ~]# systemctl enable mariadb
Failed to enable unit: Unit file mariadb.service does not exist.
[root@viking ~]# systemctl start mariadb

Wow, what a pickle. You should have full stopped after you didn't complete the backup all databases command at the beginning. That's really an essential prerequisite before doing a major version upgrade like this. Can you image the server as it sits (full VM backup or otherwise)?

I can't just re-install 10.4 again?

I have a snapshot from last night with Contabo:
SnapShot 10-2-24   02.10.2024 08:06

1. MariaDB 10.10.is EOL. It is better to upgrade MariaDB to 10.6 or 10.11.

2. Centos 8 aren't supported by MariaDB. It is EOL too.

You can upgrade MariaDB on Centos 8 to 10.10 still, but you need to download the binary packages (RPM) and install them manually. So I recommend you to upgrade MariaDB to 10.6 following the instructions:
https://wiki.centos-webpanel.com/mariadb-upgrade-from-10-2-to-10-4
with minor changes.

See
https://www.alphagnu.com/topic/23-upgrade-mariadb-1011-in-cwp-centos-7-centos-8-stream-almalinux-78-rockylinux-78/

That will guide you to the upgrade to MariaDB 10.11.x (LTS)

1. MariaDB 10.10.is EOL. It is better to upgrade MariaDB to 10.6 or 10.11.

2. Centos 8 aren't supported by MariaDB. It is EOL too.

You can upgrade MariaDB on Centos 8 to 10.10 still, but you need to download the binary packages (RPM) and install them manually. So I recommend you to upgrade MariaDB to 10.6 following the instructions:
https://wiki.centos-webpanel.com/mariadb-upgrade-from-10-2-to-10-4
with minor changes.

I run almalinux 8.9 not centos. I solved it by using a snapshot from the day before.

MariaDB 10.4.x is past EOL.

10.11.x works on AlmaLinux 8.10 and 9.4 without problems.

Curious why you haven't updated to 8.10 for the security fixes.

MariaDB 10.4.x is past EOL.

10.11.x works on AlmaLinux 8.10 and 9.4 without problems.

Curious why you haven't updated to 8.10 for the security fixes.

I run update and upgrade all the time. I do all the yum updates as well but it's a production vps with lots of sites on it and can't afford for it to be down.

I run almalinux 8.9 not centos. I solved it by using a snapshot from the day before.

For some reason your OS is recognized as CentOS. Look at the string below:

- Status code: 404 for http://mirror.mariadb.org/yum/10.10/centos8-amd64/repodata/repomd.xml (IP: 162.55.42.214)

I run update and upgrade all the time. I do all the yum updates as well but it's a production vps with lots of sites on it and can't afford for it to be down.

I strongly recommend you to update MariaDB to 10.6 instead of 10.10. The upgrade process to 10.6 should be smooth without any problems.

I would redo your mariadb.repo, and put in the info for RHEL 8, you can find this at:

https://mariadb.org/download/?t=repo-config

You can also select the closest mirror to your location.

If using AL8, you really should be using dnf, instead of yum, just to get use to the newer stuff.

Thanks

I would redo your mariadb.repo, and put in the info for RHEL 8, you can find this at:

https://mariadb.org/download/?t=repo-config

You can also select the closest mirror to your location.

If using AL8, you really should be using dnf, instead of yum, just to get use to the newer stuff.

I jusdt setup dnf automatic