Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Downgrading Binary and Package-based Installations on Unix/Linux
Let us understand how to downgrade binary and package-based installation on Unix or Linux. Downgrading binary and package based installations on Unix or Linux can be done in a variety of ways. They have discussed below.
In-Place Downgrade
In-place downgrade involves shutting down the new MySQL version.
Once this is done, the new MySQL binaries or packages are replaced with the old binaries or packages.
Once this is done, the old MySQL version is restarted on the existing data directory.
MySQL has to be configured to perform a slow shutdown by setting innodb_fast_shutdown to 0.
The below command would do the same −
mysql -u root -p --execute="SET GLOBAL innodb_fast_shutdown=0"
Shut down the newer MySQL server. This can be done using the below commands −
mysqladmin -u root -p shutdown
After the slow shutdown, the InnoDB redo log files are removed (the ib_logfile* files) from the data directory. This is done to avoid downgrade issues that are associated with the redo log file format which would have occurred between releases.
Logical Downgrade
Logical downgrade involves usage of mysqldump to dump all tables from the new MySQL version.
Once this is done, the dump file is loaded into the old MySQL version.
Logical downgrades are supported for downgrades between releases within the same release series as well as for downgrades to the previous release level.
Only downgrades between General Availability (GA) releases are supported.
Dump all the databases. This is done using the below command −
mysqldump −u root −p −−add−drop−table −−routines −−events −−all−databases −−force > data−for−downgrade.sql
The newer MySQL server is shut down using the below command −
mysqladmin −u root −p shutdown
94 Views
