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/ndb-restore-to-different-version.html
Since it is possible to restore metadata and table data separately, you can in such cases restore the table schemas from a dump made using mysqldump, or by executing the necessary CREATE TABLE statements manually, then import only the table data ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-bulk-data-loading.html
COMMIT; The mysqldump option --opt creates dump files that are fast to import into an InnoDB table, even without wrapping them with the SET autocommit and COMMIT statements. MySQL Shell's dump loading utility util.loadDump() also offers parallel ...
https://dev.mysql.com/doc/refman/8.0/en/problems-connecting.html
If you have any other problems with the MySQL grant tables and ask on the MySQL Community Slack, always provide a dump of the MySQL grant tables. In some cases, you may need to restart mysqld with --skip-grant-tables to run mysqldump. If you ...
https://dev.mysql.com/doc/refman/8.0/en/problems-with-float.html
An implication of the preceding issues is that if you attempt to create a replica by dumping table contents with mysqldump on the source and reloading the dump file into the replica, tables containing floating-point columns might differ between the ... Floating-point numbers sometimes cause confusion because they are approximate and not stored as exact ...
https://dev.mysql.com/doc/refman/8.0/en/programs-overview.html
mysqldump A client that dumps a MySQL database into a file as SQL, text, or XML. mysqlpump A client that dumps a MySQL database into a file as SQL. myisam_ftdump A utility that displays information about full-text indexes in MyISAM tables. Later ...
https://dev.mysql.com/doc/refman/8.0/en/replication-administration-status.html
Replica connections have Binlog Dump in the Command field: mysql> SHOW PROCESSLIST \G; *************************** 4. row *************************** Id: 10 User: root Host: replica1:58371 db: NULL Command: Binlog Dump Time: 777 State: Has sent all ... The most common task when managing a replication process is to ensure that replication is taking place and that there have been no errors between the replica and the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto.html
When you are using MyISAM, you must stop processing statements on the source to obtain a read-lock, then obtain its current binary log coordinates and dump its data, before permitting the source to continue executing statements. If you do not stop ... This section describes how to set up a MySQL server to use binary log file position based ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-reference.html
max-binlog-dump-events: Option used by mysql-test for debugging and testing of replication. sporadic-binlog-dump-fail: Option used by mysql-test for debugging and testing of replication. The following two sections provide basic information about ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-diffengines.html
Configuring different engines on the source and replica depends on how you set up the initial replication process: If you used mysqldump to create the database snapshot on your source, you could edit the dump file text to change the engine type used ... It does not matter for the replication process whether the original table on the source and the replicated table on the replica use different storage engine ...
https://dev.mysql.com/doc/refman/8.0/en/server-option-variable-reference.html
The following table lists all command-line options, system variables, and status variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables ...