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/mysqldump.html
To reload a dump file, you must have the privileges required to execute the statements that it contains, such as the appropriate CREATE privileges for objects created by those statements. If your tables are primarily InnoDB tables, or if you have a ... The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and table ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-mysql-cluster.html
Which versions of the MySQL software support NDB Cluster? Do I have to compile from source? A.10.2. Do I have to learn a new programming or query language to use NDB Cluster? A.10.16. Is it a good idea to have more than one management node for an ...
https://dev.mysql.com/doc/refman/8.0/en/change-replication-source-to.html
When you have set up multiple replication channels, every CHANGE REPLICATION SOURCE TO statement must name a channel using the FOR CHANNEL channel clause. CHANGE REPLICATION SOURCE TO statements have a number of side-effects and interactions that ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-parameters.html
The InnoDB storage engine can no longer be disabled, and the --innodb=OFF and --skip-innodb options are deprecated and have no effect. If an abnormal shutdown occurs, the status file may have to be removed manually. Transactions for which logs have ... InnoDB Startup Options InnoDB System Variables System variables that are true or false can be enabled at server startup by naming them, or disabled by using a --skip- ...
https://dev.mysql.com/doc/refman/8.0/en/change-master-to.html
When you have set up multiple replication channels, every CHANGE MASTER TO statement must name a channel using the FOR CHANNEL channel clause. CHANGE MASTER TO statements have a number of side-effects and interactions that you should be aware of ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog.html
You can also use mysqlbinlog to display the contents of relay log files written by a replica server in a replication setup because relay logs have the same format as binary logs. When binary log files have been encrypted, which can be done from ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-logging-configuration.html
Sequence numbers start at 1 and increase for passwords that have the same pwd_timestamp value. If multiple passwords have that pwd_timestamp value, the current password ID is the one with the largest sequence number. For example, in the preceding ...
https://dev.mysql.com/doc/refman/8.0/en/password-management.html
The global password-expiration policy applies to all accounts that have not been set to override it. The global password-reuse policy applies to all accounts that have not been set to override it. This can have unfortunate consequences: The original ... MySQL supports these password-management capabilities: Password expiration, to require passwords to be changed ...
https://dev.mysql.com/doc/refman/8.0/en/bit-functions.html
The result type depends on whether the arguments are evaluated as binary strings or numbers: Binary-string evaluation occurs when the arguments have a binary string type, and at least one of them is not a hexadecimal literal, bit literal, or NULL ...
https://dev.mysql.com/doc/refman/8.0/en/json.html
Prior to MySQL 8.0.13, a JSON column cannot have a non-NULL default value. Strings produced by converting JSON values have a character set of utf8mb4 and a collation of utf8mb4_bin: mysql> SELECT CHARSET(@j), COLLATION(@j); ...The JSON data type ...