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/cleartext-pluggable-authentication.html
The mysql, mysqladmin, mysqlcheck, mysqldump, mysqlshow, and mysqlslap client programs support an --enable-cleartext-plugin option that enables the plugin on a per-invocation basis. A client-side authentication plugin is available that enables ...
https://dev.mysql.com/doc/refman/8.0/en/connecting-using-uri-or-key-value-pairs.html
For information on establishing connections using command-line options, for clients such as mysql or mysqldump, see Section 6.2.4, “Connecting to the MySQL Server Using Command Options”. This section describes use of URI-like connection strings ...
https://dev.mysql.com/doc/refman/8.0/en/connection-compression-control.html
The --compression-algorithms and --zstd-compression-level command-line options configure permitted compression algorithms and zstd compression level for these client programs: mysql, mysqladmin, mysqlbinlog, mysqlcheck, mysqldump, mysqlimport, ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-gipks.html
The --skip-generated-invisible-primary-key option for mysqldump causes GIPK information to be excluded in the program's output. Beginning with MySQL 8.0.30, MySQL supports generated invisible primary keys for any InnoDB table that is created ...
https://dev.mysql.com/doc/refman/8.0/en/create-tablespace.html
The precise syntax and semantics depend on the storage engine used. MySQL NDB Cluster also supports tablespaces using the NDB storage engine. Considerations for InnoDB Considerations for NDB Cluster Options Notes InnoDB Examples NDB Example ...
https://dev.mysql.com/doc/refman/8.0/en/features.html
These include both command-line programs such as mysqldump and mysqladmin, and graphical programs such as MySQL Workbench. This section describes some of the important characteristics of the MySQL Database Software. In most respects, the roadmap ...
https://dev.mysql.com/doc/refman/8.0/en/import-table.html
Tables can be exported from one server using mysqldump to write a file of SQL statements and imported into another server using mysql to process the dump file. The IMPORT TABLE statement imports MyISAM tables based on information contained in .sdi ...
https://dev.mysql.com/doc/refman/8.0/en/innochecksum.html
If checksum mismatches are found, restore the tablespace from backup or start the server and attempt to use mysqldump to make a backup of the tables within the tablespace. This tool reads an InnoDB tablespace file, calculates the checksum for each ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-buffer-pool.html
A table scan, performed for a mysqldump operation or a SELECT statement with no WHERE clause, for example, can bring a large amount of data into the buffer pool and evict an equivalent amount of older data, even if the new data is never used again.
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-syntax-warnings.html
The “non-strict” behavior lets you import a mysqldump file into a database that does not support compressed tables, even if the source database contained compressed tables. This section describes syntax warnings and errors that you may ...