Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
10.0.1, 5.5.29
Description
When RPM/yum upgrade from one major version to another is attempted, it fails with a verbose error message. The text explains why such an upgrade is not recommended and suggests the right way to do it. Sometimes it mentions MySQL instead of MySQL/MariaDB which makes it rather unclear. More importantly, it suggests to find conflicting packages by grepping for 'mysql' which simply doesn't work if the old version is also MariaDB.
An example of the text generated on upgrade from MariaDB 5.5.29 to MariaDB 10.0.1 is below.
A MySQL or MariaDB server package (MariaDB-server-5.5.29-1) is installed.
|
|
|
Upgrading directly from MySQL 5.5 to MariaDB 10.0 may not
|
be safe in all cases. A manual dump and restore using mysqldump is
|
recommended. It is important to review the MariaDB manual's Upgrading
|
section for version-specific incompatibilities.
|
|
|
A manual upgrade is required.
|
|
|
- Ensure that you have a complete, working backup of your data and my.cnf
|
files
|
- Shut down the MySQL server cleanly
|
- Remove the existing MySQL packages. Usually this command will
|
list the packages you should remove:
|
rpm -qa | grep -i '^mysql-'
|
|
|
You may choose to use 'rpm --nodeps -ev <package-name>' to remove
|
the package which contains the mysqlclient shared library. The
|
library will be reinstalled by the MariaDB-shared package.
|
- Install the new MariaDB packages supplied by Monty Program AB
|
- Ensure that the MariaDB server is started
|
- Run the 'mysql_upgrade' program
|
|
|
This is a brief description of the upgrade process. Important details
|
can be found in the MariaDB manual, in the Upgrading section.A MySQL or MariaDB server package (MariaDB-server-5.5.29-1) is installed.
|
|
|
Upgrading directly from MySQL 5.5 to MariaDB 10.0 may not
|
be safe in all cases. A manual dump and restore using mysqldump is
|
recommended. It is important to review the MariaDB manual's Upgrading
|
section for version-specific incompatibilities.
|
|
|
A manual upgrade is required.
|
|
|
- Ensure that you have a complete, working backup of your data and my.cnf
|
files
|
- Shut down the MySQL server cleanly
|
- Remove the existing MySQL packages. Usually this command will
|
list the packages you should remove:
|
rpm -qa | grep -i '^mysql-'
|
|
|
You may choose to use 'rpm --nodeps -ev <package-name>' to remove
|
the package which contains the mysqlclient shared library. The
|
library will be reinstalled by the MariaDB-shared package.
|
- Install the new MariaDB packages supplied by Monty Program AB
|
- Ensure that the MariaDB server is started
|
- Run the 'mysql_upgrade' program
|
|
|
This is a brief description of the upgrade process. Important details
|
can be found in the MariaDB manual, in the Upgrading section.
|
Attachments
Issue Links
- is duplicated by
-
-
- Closed
-
- is part of
-
MDEV-22315 MySQL -> MariaDB upgrades
-
- Open
-
-
-
- Open
-
- relates to
-
-
- Stalled
-