content_image/852996.jpg content_image/852995.jpg
Deprecated, or Removed in MySQL 8.0” . If you use any of these, an upgrade requires configuration changes. 

Example: Because the data dictionary provides information about database objects, the server no longer checks directory names in the data directory to find databases. Consequently, the --ignore- db-dir  option is extraneous and has been removed. To handle this, remove any instances of -- ignore-db-dir  from your startup configuration. In addition, remove or move the named data directory subdirectories before upgrading to MySQL 8.0. (Alternatively, let the 8.0 server add those directories to the data dictionary as databases, then remove each of those databases using DROP DATABASE .) 

12. If you intend to change the lower_case_table_names  setting to 1 at upgrade time, ensure that schema and table names are lowercase before upgrading. Otherwise, a failure could occur due to a schema or table name lettercase mismatch. You can use the following queries to check for schema and table names containing uppercase characters: 

mysql> mysql> SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME != LOWER(SCHEMA_NAME); 

As of MySQL 8.0.19, if lower_case_table_names=1 , table and schema names are checked by the upgrade process to ensure that all characters are lowercase. If table or schema names are found to contain uppercase characters, the upgrade process fails with an error. 

<img src='content_image/852996.jpg'>

## Note 

Changing the lower_case_table_names  setting at upgrade time is not recommended. 

If upgrade to MySQL 8.0 fails due to any of the issues outlined above, the server reverts all changes to the data directory. In this case, remove all redo log files and restart the MySQL 5.7 server on the existing data directory to address the errors. The redo log files ( ib_logfile* ) reside in the MySQL data directory by default. After the errors are fixed, perform a slow shutdown (by setting innodb_fast_shutdown=0 ) before attempting the upgrade again. 

## 2.11.6 Upgrading MySQL Binary or Package-based Installations on Unix/Linux 

This section describes how to upgrade MySQL binary and package-based installations on Unix/Linux. In- place and logical upgrade methods are described. 

## In-Place Upgrade 

•In-Place Upgrade 

•Logical Upgrade 

•MySQL Cluster Upgrade 

An in-place upgrade involves shutting down the old MySQL server, replacing the old MySQL binaries or packages with the new ones, restarting MySQL on the existing data directory, and upgrading any remaining parts of the existing installation that require upgrading. For details about what may need upgrading, see Section 2.11.3, “What the MySQL Upgrade Process Upgrades” . 

<img src='content_image/852995.jpg'>

## Note 

If you are upgrading an installation originally produced by installing multiple RPM packages, upgrade all the packages, not just some. For example, if you previously installed the server and client RPMs, do not upgrade just the server RPM. 

