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