MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 171 to 178 of 178 total results

« Previous
16
17
18
Next »

https://dev.mysql.com/doc/refman/8.0/en/upgrade-before-you-begin.html

The backup should include the mysql system database, which contains the MySQL data dictionary tables and system tables. Important Downgrade from MySQL 8.0 to MySQL 5.7, or from a MySQL 8.0 release to a previous MySQL 8.0 release, is not supported.

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

https://dev.mysql.com/doc/refman/8.0/en/upgrade-binary-package.html

This section describes how to upgrade MySQL binary and package-based installations on Unix/Linux. In-Place Upgrade Logical Upgrade MySQL Cluster Upgrade In-Place Upgrade An in-place upgrade involves shutting down the old MySQL server, replacing the ...

3.13 Upgrade Troubleshooting

https://dev.mysql.com/doc/refman/8.0/en/upgrade-troubleshooting.html

A schema mismatch in a MySQL 5.7 instance between the .frm file of a table and the InnoDB data dictionary can cause an upgrade to MySQL 8.0 to fail. To address this issue, dump and restore affected tables before attempting the upgrade again. If ...

Chapter 3 Upgrading MySQL

https://dev.mysql.com/doc/refman/8.0/en/upgrading.html

This chapter describes the steps to upgrade a MySQL installation. Upgrading is a common procedure, as you pick up bug fixes within the same MySQL release series or significant features between major MySQL releases. You perform this procedure first ...

10.2.1.1 WHERE Clause Optimization

https://dev.mysql.com/doc/refman/8.0/en/where-optimization.html

This section discusses optimizations that can be made for processing WHERE clauses. The examples use SELECT statements, but the same optimizations apply for WHERE clauses in DELETE and UPDATE statements. Note Because work on the MySQL optimizer is ...

2.1.2 Which MySQL Version and Distribution to Install

https://dev.mysql.com/doc/refman/8.0/en/which-version.html

When preparing to install MySQL, decide which version and distribution format (binary or source) to use. First, decide whether to install from a bugfix series like MySQL 8.4, or use an innovation release like MySQL 9.4. Both tracks include bug ...

2.3.4.5 Starting the Server for the First Time

https://dev.mysql.com/doc/refman/8.0/en/windows-server-first-start.html

This section gives a general overview of starting the MySQL server. The following sections provide more specific information for starting the MySQL server from the command line or as a Windows service. The information here applies primarily if you ...

22.5.6.2 X Plugin Options and System Variables

https://dev.mysql.com/doc/refman/8.0/en/x-plugin-options-system-variables.html

To control activation of X Plugin, use this option: --mysqlx[=value] Command-Line Format --mysqlx[=value] Type Enumeration Default Value ON Valid Values ONOFFFORCEFORCE_PLUS_PERMANENT This option controls how the server loads X Plugin at startup.