PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/channels-with-prev-replication.html
When a replica has multiple channels and a FOR CHANNEL channel option is not specified, a valid statement generally acts on all available channels, with some specific exceptions. For example, the following statements behave as expected for all ...
https://dev.mysql.com/doc/refman/8.0/en/charset-conversion.html
If you use a binary column to store information in multiple character sets, MySQL has no way to know which values use which character set and cannot convert the data properly. If the contents are encoded in a different character set, you can convert ... To convert a binary or nonbinary string column to use a particular character set, use ALTER ...
https://dev.mysql.com/doc/refman/8.0/en/charset-metadata.html
Thus column names, database names, user names, version names, and most of the string results from SHOW are metadata. Otherwise, users would not be able to name columns and tables using their own languages. The metadata requirements mean that the ...
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 ...