The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-17. For the latest, interactive version please visit https://mariadb.com/kb/.

Can't use my PMB database after upgrading to version 10.1.44-MariaDB...

Hi,

I'm using PMB SIGB with a huge database from many years. Recently I upgrade my Linux system with Linux Mint 19 and package 10.1.44-MariaDB. Then phpmyadmin show "used" information for a lot of tables types, so no InoDB =, no Isam, but "used"... I understand it was tables not recognized by MariaDB engine. So I arttempted a mysql_upgrade but then again with full messages to say about same tables "not recognize by engine" or something like that...

Then I would like to install a MariaDB backward version, but first I needed to know wich version my tables files used. I finded a web page "How to obtain the MySQL version from an FRM file" : https://www.percona.com/blog/2015/07/09/obtain-mysql-version-frm-file/

Then I apllied it to one of my tables :

hexdump -s 0x33 -n 2 -v -d authorities.frm 0000033 34500 0000035

I could understand i would be MariaDB 5.34 ...??? But I'm not sure. I can't give you my authorities.frm file here... So I attempted to load a bacward package for MariaDB and my Linux Mint 19 show me :

1:10.1.44-0Ubunto0.18.04.1 (bionic-updates) 1:10.1.29-6 (bionic)

So I tested the last, 1:10.1.29-6 (bionic), but it looks like same version because first one could be only an update... And then, mysql -version display 10.1.44 always.

So, what can I do ?

thank you for your help.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.