如何从SQL转储文件升级mariadb?

本文介绍了如何从SQL转储文件升级mariadb?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我有一个由mariadb 10.2的mysqldump生成的sql转储文件.

I have a sql dump file generated by mysqldump of mariadb 10.2.

我想使用mariadb 10.4设置新的数据库服务器，数据来自sql dump文件.

I want to set up a new db server using mariadb 10.4 with data coming from the sql dump file.

在这种情况下是否需要升级过程?如果是这样，我应该先将sql文件还原到db中，然后运行mysql_upgrade还是以某种方式直接升级sql文件，然后还原到db中?

Is the upgrade process necessary in this case? If so, should I first restore the sql file into db and then run mysql_upgrade or somehow directly upgrade the sql file and then restore into the db?

推荐答案

好吧，我建议您遵循MariaDb网站上提供的升级指南.请参阅升级 MariaDB.它列出了有关从一个主要版本的MariaDb升级到另一个主要版本的文章.

Well I would suggest that you follow the upgrade guides given on the MariaDb website. See Upgrading MariaDB. It lists articles on upgrading from one major version of MariaDb to the next.

没有直接从版本10.2升级到10.4的指南，因此您应该首先通过遵循从MariaDB 10.2升级到MariaDB 10.3 .然后按照从MariaDB升级，从10.3升级到10.4.10.3到MariaDB 10.4 .

There is no guide for directly upgrading from version 10.2 to 10.4, so you should first upgrade from 10.2 to 10.3 by following Upgrading from MariaDB 10.2 to MariaDB 10.3. Then upgrade from 10.3 to 10.4 by following Upgrading from MariaDB 10.3 to MariaDB 10.4.

请务必阅读主要版本之间的不兼容性

Make sure to read the incompatibilities between the major versions