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

You are viewing an old version of this question. View the current version here

Revision: 98104
User: Patrick gelin
Date: 2020-08-06 05:05

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.

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

Products

Services

Pricing

Resources

About Us

Download MariaDB