Re: upbrade database mysql 5.5.62 -> MariaDB 10.3.34

On Fri, Apr 8, 2022 at 1:47 AM Toshi Esumi <[email protected]> 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