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/mysql-nutshell.html
As part of this work, a new --skip-generated-invisible-primary-key option is added to mysqldump and mysqlpump to exclude generated invisible primary keys, columns, and column values from their output. This could be problematic in certain cases, such ... This section summarizes what has been added to, deprecated in, and removed from MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/option-files.html
For example, a [client] group is more general because it is read by all client programs, whereas a [mysqldump] group is read only by mysqldump. Options specified later override options specified earlier, so putting the option groups in the order ...
https://dev.mysql.com/doc/refman/8.0/en/rebuilding-tables.html
If you need to rebuild an InnoDB table because a CHECK TABLE operation indicates that a table upgrade is required, use mysqldump to create a dump file and mysql to reload the file. This section describes how to rebuild or repair tables or indexes, ...
https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html
As of MySQL 5.7.24 and MySQL 8.0.13, mysqldump removes NO_AUTO_CREATE_USER from stored program definitions. Dump files created with an earlier version of mysqldump must be modified manually to remove instances of NO_AUTO_CREATE_USER. They can no ...
https://dev.mysql.com/doc/refman/8.0/en/alter-database.html
This has implications for mysqldump and mysqlpump, which use SHOW CREATE DATABASE to produce CREATE DATABASE statements in dump output: In a dump file, the CREATE DATABASE statement for a read-only database contains the commented READ ONLY option.
https://dev.mysql.com/doc/refman/8.0/en/create-table-foreign-keys.html
As the default, an ON DELETE NO ACTION or ON UPDATE NO ACTION clause that is specified explicitly does not appear in SHOW CREATE TABLE output or in tables dumped with mysqldump. RESTRICT, which is an equivalent non-default keyword, appears in SHOW ... MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-backup.html
Logical Backups Using mysqldump In addition to physical backups, it is recommended that you regularly create logical backups by dumping your tables using mysqldump. mysqldump also has a --single-transaction option for making a consistent snapshot ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-preparation.html
ndb-connectstring=management_host[:port] In the event that you are not using NDB Cluster on the replica, you can create a backup with this command on the source: shellS> mysqldump --master-data=1 Then import the resulting data dump onto the replica ... Preparing the NDB Cluster for replication consists of the following steps: Check all MySQL servers for version compatibility (see Section 25.7.2, “General Requirements for NDB Cluster ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-config-editor.html
For example, a client login path is more general because it is read by all client programs, whereas a mysqldump login path is read only by mysqldump. Options specified later override options specified earlier, so putting the login paths in the order ... The mysql_config_editor utility enables you to store authentication credentials in an obfuscated login path file named ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-functions.html
The procedure used is to back up server2 using mysqldump, then to restore this backup on server1. Provided that mysqldump was run with --set-gtid-purged set to ON or AUTO (the default), the output contains a SET @@GLOBAL.gtid_purged statement which ... This section provides examples of stored functions (see Chapter 27, Stored Objects) which you can create using some of the built-in functions provided by MySQL for use with GTID-based replication, listed here: GTID_SUBSET(): Shows whether one GTID set is a subset of ...