PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysqlpump.html
If --add-drop-database is used with --all-databases or with --databases where the list of schemas to be dumped includes mysql, the dump file contains a DROP DATABASE `mysql` statement that causes an error when the dump file is reloaded. To reload a ... mysqlpump Invocation Syntax mysqlpump Option Summary mysqlpump Option Descriptions mysqlpump Object Selection mysqlpump Parallel Processing mysqlpump Restrictions The mysqlpump 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/password-too-long.html
This occurs when the library provided by the system to read passwords limits password values to a small number of characters (typically eight). That is a problem with the system library, not with MySQL. To work around it, change your MySQL password ...
https://dev.mysql.com/doc/refman/8.0/en/memory-storage-engine.html
Loading Data To populate a MEMORY table when the MySQL server starts, you can use the init_file system variable. SELECT or LOAD DATA into a file to load the table from a persistent data source, and use init_file to name the file. Because the data is ... The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in ...
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-apt-repo.html
The MySQL APT repository provides deb packages for installing and managing the MySQL server, client, and other components on the current Debian and Ubuntu releases. Instructions for using the MySQL APT Repository are available in A Quick Guide to ...
https://dev.mysql.com/doc/refman/8.0/en/import-table.html
Given those file names, the copy commands look like this: $> cd export_basedir/data/hr $> cp employees_125.sdi /tmp/export $> cp managers_238.sdi /tmp/export $> cp employees.{MYD,MYI} /tmp/export $> cp managers.{MYD,MYI} /tmp/export Unlock the ...To ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-nodes-groups.html
Note All node groups in an NDB Cluster must have the same number of data nodes. This section discusses the manner in which NDB Cluster divides and duplicates data for storage. It is common for the terms “node” and “data node” to be used ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-stage-tables.html
The Performance Schema tables provide a container to store progress data, but make no assumptions about the semantics of the metric itself: A “work unit” is an integer metric that increases over time during execution, such as the number of ...
https://dev.mysql.com/doc/refman/8.0/en/replication-setup-replicas.html
Obtained the source status information, or a copy of the source's binary log index file made during a shutdown for the data snapshot. If you are setting up a new replication environment using the data from a different existing database server to ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-upgrade-downgrade.html
NDB 8.0.22 adds support for IPv6 addressing for management nodes and data nodes in the config.ini file. The EncryptedFileSystem configuration parameter, introduced in NDB 8.0.29, could in some cases cause undo log files to be encrypted, even when ...
https://dev.mysql.com/doc/refman/8.0/en/alter-instance.html
ALTER INSTANCE RELOAD KEYRING If a keyring component is installed, this action tells the component to re-read its configuration file and reinitialize any keyring in-memory data. ALTER INSTANCE instance_action instance_action: { | {ENABLE|DISABLE} ...This feature is intended only for loading data into a new MySQL ...