On 4/8/22 04:45, Jeffrey Walton wrote:
On Fri, Apr 8, 2022 at 1:47 AM Toshi Esumi email2@toshiesumi.com wrote:
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"
Related, we have a lot of luck using mysqldump to backup our wiki database. I have tested the restores and they are Ok. https://github.com/weidai11/website/blob/master/systemd/bitvise-backup#L80 and https://stackoverflow.com/q/105776.
I have not tested a MySQL backup followed by a MariaDB restore.
You might try it and see if it works for you.
Jeff
Ok, thank you for additional tips.
Toshi