Search Results
https://dev.mysql.com/doc/refman/8.4/en/backup-methods.html
If you are backing up a replica, you should back up its connection metadata repository and applier metadata repository (see Section 19.2.4, “Relay Log and Replication Metadata Repositories”) when you back up the replica's databases, regardless ...Making a Hot Backup with MySQL Enterprise Backup Customers of MySQL Enterprise Edition can use the MySQL Enterprise Backup product to do physical backups of entire instances or selected databases, tables, or ...
https://dev.mysql.com/doc/refman/8.4/en/batch-mode.html
In the previous sections, you used mysql interactively to enter statements and view the results. If you want the script to continue even if some of the statements in it produce errors, you should use the --force command-line option. Why use a ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-mixed.html
The following system variables, when used with session scope (only), do not cause the logging format to switch: auto_increment_increment auto_increment_offset character_set_client character_set_connection character_set_database character_set_server ... When running in MIXED logging format, the server automatically switches from statement-based to row-based logging under the following conditions: When a function contains ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-setting.html
You can select the binary logging format explicitly by starting the MySQL server with --binlog-format=type. The supported values for type are: STATEMENT causes logging to be statement based. Setting the binary logging format does not activate ...
https://dev.mysql.com/doc/refman/8.4/en/cannot-initialize-character-set.html
You might see an error like this if you have character set problems: MySQL Connection Failed: Can't initialize character set charset_name This error can have any of the following causes: The character set is a multibyte character set and you have ...In this case, you need to recompile the client by running CMake with the -DDEFAULT_CHARSET=charset_name ...
https://dev.mysql.com/doc/refman/8.4/en/changing-mysql-user.html
mysqld starts, then switches to run as the Unix user user_name before accepting any connections. On Windows, you can run the server as a Windows service using a normal user account. On Linux, for installations performed using a MySQL repository or ...
https://dev.mysql.com/doc/refman/8.4/en/charset-errors.html
For more information about character_set_results, see Section 12.4, “Connection Character Sets and Collations”. This section describes how the MySQL server uses character sets for constructing error messages. For information about the language ...
https://dev.mysql.com/doc/refman/8.4/en/charset-metadata.html
(See Section 12.4, “Connection Character Sets and Collations”.) Alternatively, a client program can perform the conversion after receiving the result from the server. Metadata is “the data about the data.” Anything that describes the ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode-conversion.html
The following items summarize other potential incompatibilities: SET NAMES 'utf8mb4' causes use of the 4-byte character set for connection character sets. This section describes issues that you may face when converting character data between the ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-limitations.html
Connecting to the donor MySQL server instance through MySQL Router is not supported. The clone plugin is subject to these limitations: An instance cannot be cloned from a different MySQL server series. For example, you cannot clone between MySQL ...