PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/upgrade-best-practices.html
Run Upgrade Checker and Fix Incompatibilities MySQL Shell's Upgrade Checker Utility detects incompatibilities between database versions that must be addressed before performing the upgrade. These include incompatibilities in data types, storage ...
https://dev.mysql.com/doc/refman/8.0/en/regexp.html
To specify a literal open ( or close parenthesis ) in a regular expression, it must be escaped: mysql> SELECT REGEXP_LIKE('(', '('); ERROR 3692 (HY000): Mismatched parenthesis in regular expression. Match any character (including carriage return and ...This section discusses the functions and operators available for regular expression matching and illustrates, with examples, some of the special characters and constructs that can be used for regular expression ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto-slavebaseconfig.html
Each replica must have a unique server ID, as specified by the server_id system variable. If you are setting up multiple replicas, each one must have a unique server_id value that differs from that of the source and from any of the other replicas.
https://dev.mysql.com/doc/refman/8.0/en/partial-revokes.html
For any account to which the schema should be accessible, the DBA must grant schema-level access. Adding a new account: The DBA must grant schema-level access for each schema to which the account should have access. For any such account to which the ...As of MySQL 8.0.16, that is possible if the partial_revokes system variable is ... Prior to MySQL 8.0.16, ...
https://dev.mysql.com/doc/refman/8.0/en/downgrading.html
Attempting to downgrade below MySQL 8.0.35 yields an error similar to: [ERROR] [MY-013171] [InnoDB] Cannot boot server version 80034 on data directory built by version 80035. In-place downgrades are supported from within the MySQL 8.0 series as of ... Downgrading from MySQL 8.0 to MySQL 5.7 is not ...
https://dev.mysql.com/doc/refman/8.0/en/solaris-installation-pkg.html
(default: all) [?,??,q]: The PKG installer installs all of the files and tools needed, and then initializes your database if one does not exist. To upgrade when using the Solaris package file format, you must remove the existing installation before ...To use this package, download the corresponding mysql-VERSION-solaris11-PLATFORM.pkg.gz file, then uncompress ... You can install ...
https://dev.mysql.com/doc/refman/8.0/en/validate-password-transitioning.html
(Any option file changes that must be made are performed in the next step.) Adjust any references to the plugin system and status variables to refer to the corresponding component system and status variables. Suppose that previously you had ...In ...
https://dev.mysql.com/doc/refman/8.0/en/alter-function.html
ALTER FUNCTION func_name [characteristic ...] characteristic: { COMMENT 'string' | LANGUAGE SQL | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA } | SQL SECURITY { DEFINER | INVOKER } } This statement can be used to change the ...More ...
https://dev.mysql.com/doc/refman/8.0/en/alter-procedure.html
ALTER PROCEDURE proc_name [characteristic ...] characteristic: { COMMENT 'string' | LANGUAGE SQL | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA } | SQL SECURITY { DEFINER | INVOKER } } This statement can be used to change the ...By ...More than one change may be specified in an ALTER PROCEDURE ...
https://dev.mysql.com/doc/refman/8.0/en/metadata-locking.html
Metadata Lock Release To ensure transaction serializability, the server must not permit one session to perform a data definition language (DDL) statement on a table that is used in an uncompleted explicitly or implicitly started transaction in ...