Upgraded version of MariaDB still dumps older version

Question

EDIT: Found out what I was doing wrong. I was using mariadb-dump to import instead of just mariadb.

I upgraded from MariaDB 10.x to 11.x. mariadb -V is showing the updated version.

I exported the database (which was retained during upgrade) via MySQL/MariaDB-dump and got the infamous sandbox error.

Using sed or piping commands, we can get it uploaded, but it's annoying.

We ran mariadb-upgrade and it still had the same error.

/*M!999999\- enable the sandbox mode */
-- MariaDB dump 10.19-11.5.2-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database:
-- ------------------------------------------------------
-- Server version       11.5.2-MariaDB-ubu2204

Logically, two things could be going on. One is that somehow the dump program is still the older version, possibly because it was never overwritten despite the rest being upgraded.

Second possibility is that the database itself is still the older version. Either because mariadb-upgrade was incorrect or maybe a new database has to be made under the current MariaDB.

I have not tried mariabackup yet, but that looks like a possible solution.

Question: How can I troubleshoot this, and any potential solutions?

EDIT: To clarify the import/export command I am using goes like this;

For export:

mariadb-dump -u username -p DBname > filename.sql

Import:

mariadb-dump -u username -p DBname < filename.sql

NOTE: I used both mariadb-dump and mysql dump (which just switched to maria).

EDIT 2:

So I think the database is exporting fine. The issue is that my database may be corrupted. /M!999999\ is different than /!999999\ sandbox bug. Looks like an M was inserted.

Answer 1

Found out what I was doing wrong. I was using mariadb-dump to import instead of just mariadb. I'm used to using mysql/mysqldump.

Answer 2

I think you've updated the database instance, the server so to speak, so the database files are still in the older version.

Have you done a

SELECT VERSION();

in a selected database to check the version?