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