Re: upbrade database mysql 5.5.62 -> MariaDB 10.3.34

On 4/8/22 04:45, Jeffrey Walton wrote:
> 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

Ok, thank you for additional tips.

Toshi

-- 
Toshi Esumi
web: http://www.toshiesumi.com
blog: http://toshiesumi.blogspot.com