upbrade database mysql 5.5.62 -> MariaDB 10.3.34

Hello,

I'm trying to upgrade/migrate my mediawiki from my old Ubuntu VM 14.04 
to a new Ubuntu VM 20.04. The detail of the components are below. I 
managed to set up a new mediawiki 1.37.2 with MariaDB at the new VM and 
copied images directory tree and converted LocalSettings.php to make it 
workable but when I restored mysql DB into mariaDB with "mysql -u root 
-p toshiwiki(my DB name) < toshiwikibackup.sql", I got "Database error" 
at the main page with the detail below:

[a50bfc1261fc29c06a343aec] 2022-04-08 05:32:47: Fatal exception of type 
"Wikimedia\Rdbms\DBQueryError"

Can someone tell me where to start debugging or fixing my database to 
let MariaDB to understand the imported DB properly? I'm willing/wanting 
to learn MySQL/MariaDB more to understand the SQL command and DB 
structure to be able to fix problem like this. I'm guessing I need to 
modify mysqldump file before restoring it. But just don't know where to 
start.


Thanks,


Toshi

***

Old environment:

Ubuntu 14.04

Mediawiki 1.26.0

PHP 5.5.9

MySQL 5.5.672


New environment:

Ubuntu 20.04

Mediawiki  1.37.2

PHP  7.4.3

MariaDB  10.3.34

ICU  66.1

-- 
Toshi Esumi
web: http://www.toshiesumi.com
blog: http://toshiesumi.blogspot.com
_______________________________________________
MediaWiki-l mailing list -- [email protected]
To unsubscribe send an email to [email protected]
https://lists.wikimedia.org/postorius/lists/mediawiki-l.lists.wikimedia.org/