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/components.html
The following sections describe how to install and uninstall components, and how to determine at runtime which components are installed and obtain information about them. A component provides services that are available to the server and other ...
https://dev.mysql.com/doc/refman/8.0/en/copying-databases.html
You can then transfer the file to the other machine and feed it as input to the mysql client. Check the description for mysqldump's --set-gtid-purged option to find what happens with the versions you are using, and how to change the behavior if the ... In cases where you need to transfer databases between different architectures, you can use mysqldump to create a file containing SQL ...
https://dev.mysql.com/doc/refman/8.0/en/create-server.html
server_name has a maximum length of 64 characters (names longer than 64 characters are silently truncated), and is case-insensitive. The wrapper_name is an identifier and may be quoted with single quotation marks. Character literals are UTF-8, ...
https://dev.mysql.com/doc/refman/8.0/en/data-directory.html
Each subdirectory of the data directory is a database directory and corresponds to a database managed by the server. All MySQL installations have certain standard databases: The mysql directory corresponds to the mysql system schema, which contains ... Information managed by the MySQL server is stored under a directory known as the data ...
https://dev.mysql.com/doc/refman/8.0/en/ddl-rewriter.html
MySQL 8.0.16 and higher includes a ddl_rewriter plugin that modifies CREATE TABLE statements received by the server before it parses and executes them. The plugin removes ENCRYPTION, DATA DIRECTORY, and INDEX DIRECTORY clauses, which may be helpful ...For example, the plugin may enable restoring such dump files into an unencrypted instance or in an environment where the paths outside the data directory are not ...
https://dev.mysql.com/doc/refman/8.0/en/default-privileges.html
On all platforms, the MySQL distribution includes mysql_secure_installation, a command-line utility that automates much of the process of securing a MySQL installation. On all platforms, MySQL Workbench is available and offers the ability to manage ... The MySQL installation process involves initializing the data directory, including the grant tables in the mysql system schema that define MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/error-creating-innodb.html
Runtime Problems If InnoDB prints an operating system error during a file operation, usually the problem has one of the following solutions: Make sure the InnoDB data file directory and the InnoDB log directory exist. Initialization Problems If ...
https://dev.mysql.com/doc/refman/8.0/en/example-auto-increment.html
For example: INSERT INTO animals (id,name) VALUES(NULL,'squirrel'); When you insert any other value into an AUTO_INCREMENT column, the column is set to that value and the sequence is reset so that the next automatically generated value follows ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-information-schema.html
What is the difference between the Oracle Data Dictionary and MySQL INFORMATION_SCHEMA? A.7.5. (ANSI makes them available for purchase.) However, there are books available, such as SQL-99 Complete, Really by Peter Gulutzan and Trudy Pelzer, that ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-changing-group-mode.html
Changing to Single-Primary Mode Use the group_replication_switch_to_single_primary_mode() function to change a group running in multi-primary mode to single-primary mode by issuing: SELECT group_replication_switch_to_single_primary_mode() When you ... This section explains how to change the mode which a group is running in, either single or ...