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/channels-with-prev-replication.html
In this case, error 1964 Multiple channels exist on the replica. When a replica has multiple channels and a FOR CHANNEL channel option is not specified, a valid statement generally acts on all available channels, with some specific exceptions. For ...
https://dev.mysql.com/doc/refman/8.0/en/charset-collation-compatibility.html
Therefore, the following statement causes an error message because the latin2_bin collation is not legal with the latin1 character set: mysql> SELECT _latin1 'x' COLLATE latin2_bin; ERROR 1253 (42000): COLLATION 'latin2_bin' is not valid for ...
https://dev.mysql.com/doc/refman/8.0/en/checking-gpg-signature-windows.html
Figure 2.5 Kleopatra: the Decrypt and Verify Results Dialog: All operations completed Seeing a red The signature is bad error means the file is invalid. Do not execute the MSI file if you see this error. The Section 2.1.4.2, “Signature Checking ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-compressed-data.html
If file system block sizes differ, an error similar to the following is reported: ERROR 3868 (HY000): Clone Configuration FS Block Size: Donor value: 114688 is different from Recipient value: 4096. The following requirements apply when cloning ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-local.html
Attempting to clone such tables or tablespaces causes the following error: ERROR 1086 (HY000): File '/path/to/tablespace_name.ibd' already exists. The BACKUP_ADMIN privilege is required to execute CLONE LOCAL DATA DIRECTORY statements. mysql> GRANT ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-replication.html
If the required binary logs are not available, a replication handshake error is reported. In this case, an error message is issued, and you must set the channel up manually. In addition to cloning data, a cloning operation extracts replication ...
https://dev.mysql.com/doc/refman/8.0/en/connecting.html
If named-pipe connections are not supported or if the user making the connection is not a member of the Windows group specified by the named_pipe_full_access_group system variable, an error occurs. If the server was not started with the named_pipe ... This section describes use of command-line options to specify how to establish connections to the MySQL server, for clients such as mysql or ...
https://dev.mysql.com/doc/refman/8.0/en/connection-control-plugin-installation.html
For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_NAME LIKE 'connection%'; +------------------------------------------+---------------+ | PLUGIN_NAME | PLUGIN_STATUS | ... This section describes how ...
https://dev.mysql.com/doc/refman/8.0/en/constraint-primary-key.html
Normally, errors occur for data-change statements (such as INSERT or UPDATE) that would violate primary-key, unique-key, or foreign-key constraints. If you are using a nontransactional storage engine, MySQL stops processing the statement at the row ...If you are using a transactional storage engine such as InnoDB, MySQL automatically rolls back the ...
https://dev.mysql.com/doc/refman/8.0/en/correlated-subqueries.html
A correlated subquery is a subquery that contains a reference to a table that also appears in the outer query. For example: SELECT * FROM t1 WHERE column1 = ANY (SELECT column1 FROM t2 WHERE t2.column2 = t1.column2); Notice that the subquery ...