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
_______________________________________________
MediaWiki-l mailing list -- [email protected]
To unsubscribe send an email to [email protected]
https://lists.wikimedia.org/postorius/lists/mediawiki-l.lists.wikimedia.org/
