PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/ddl-rewriter.html
The plugin removes ENCRYPTION, DATA DIRECTORY, and INDEX DIRECTORY clauses, which may be helpful when restoring tables from SQL dump files created from databases that are encrypted or that have their tables stored outside the data directory. For ...
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. Dumped tables are stored into text files that are human-readable, so spotting table ... The key to safe database management is making regular ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-file-defragmenting.html
Another way to perform a defragmentation operation is to use mysqldump to dump the table to a text file, drop the table, and reload it from the dump file. Random insertions into or deletions from a secondary index can cause the index to become ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-recovery.html
In some cases of database corruption, it is enough to dump, drop, and re-create one or a few corrupt tables. If MySQL still has trouble starting because of InnoDB consistency problems, see Section 17.21.3, “Forcing InnoDB Recovery” for steps to ...To achieve point-in-time recovery after restoring a backup, you can apply changes from the binary log that occurred after the backup was ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-mgm-client-commands.html
For testing and diagnostics work, the client supports a DUMP command which can be used to execute internal commands on the cluster. In addition to the central configuration file, a cluster may also be controlled through a command-line interface ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-import.html
ndb_import imports CSV-formatted data, such as that produced by mysqldump --tab, directly into NDB using the NDB API. Table 25.35 Command-line options used with the program ndb_import Format Description Added, Deprecated, or Removed ...ndb_import ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-move-data.html
Usage The program is invoked with the names of the source and target tables; either or both of these may be qualified optionally with the database name. ndb_move_data options source target Options that can be used with ndb_move_data are shown in the ...
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-cluster-upgrade-downgrade.html
A dump of any version X tables not stored in NDB. Restore a file system that is compatible from a backup taken prior to the upgrade (see Section 9.4, “Using mysqldump for Backups”). Versions Supported for Upgrade to NDB 8.0 Reverting an NDB ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump-tips.html
This section surveys techniques that enable you to use mysqldump to solve specific problems: How to make a copy a database How to copy a database from one server to another How to dump stored programs (stored procedures and functions, triggers, and ...