On Fri, Apr 8, 2022 at 1:47 AM Toshi Esumi <ema...@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 _______________________________________________ MediaWiki-l mailing list -- mediawiki-l@lists.wikimedia.org To unsubscribe send an email to mediawiki-l-le...@lists.wikimedia.org https://lists.wikimedia.org/postorius/lists/mediawiki-l.lists.wikimedia.org/
