Search Results
https://dev.mysql.com/doc/refman/9.7/en/backup-strategy-example.html
Information about this recovery process is conveyed to the user through the MySQL error log. You should include such options as necessary to enable client programs to connect to the MySQL server. Assume that data is stored in the InnoDB storage ...
https://dev.mysql.com/doc/refman/9.7/en/binary-installation.html
These include generic binary distributions in the form of compressed tar files (files with a .tar.xz extension) for a number of platforms, and binaries in platform-specific package formats for selected platforms. This section covers the installation ...
https://dev.mysql.com/doc/refman/9.7/en/binary-log-transaction-compression.html
If an error is found applying any event within the Transaction_payload_event, the complete transaction is reported to the co-ordinator as having failed. MySQL supports binary log transaction compression; when this is enabled, transaction payloads ...
https://dev.mysql.com/doc/refman/9.7/en/blackhole-storage-engine.html
In this scenario replication fails with a duplicate entry error on the primary key column. The BLACKHOLE storage engine acts as a “black hole” that accepts data but throws it away and does not store it. To examine the source for the BLACKHOLE ...
https://dev.mysql.com/doc/refman/9.7/en/cannot-find-table.html
Even for file systems that are not case-sensitive, such as on Windows, all references to a given table within a query must use the same lettercase. You can check which tables are in the default database with SHOW TABLES.
https://dev.mysql.com/doc/refman/9.7/en/case.html
If no when_value or search_condition matches the value tested and the CASE statement contains no ELSE clause, a Case not found for CASE statement error results. CASE case_value WHEN when_value THEN statement_list [WHEN when_value THEN ...
https://dev.mysql.com/doc/refman/9.7/en/charset-configuration.html
The MySQL server has a compiled-in default character set and collation. To change these defaults, use the --character-set-server and --collation-server options when you start the server. The collation must be a legal collation for the default ...
https://dev.mysql.com/doc/refman/9.7/en/charset-metadata.html
Error messages returned from the server to the client are converted to the client character set automatically, as with metadata. Metadata is “the data about the data.” Anything that describes the database—as opposed to being the contents of ...
https://dev.mysql.com/doc/refman/9.7/en/charset-server.html
MySQL Server has a server character set and a server collation. By default, these are utf8mb4 and utf8mb4_0900_ai_ci, but they can be set explicitly at server startup on the command line or in an option file and changed at runtime. Initially, the ...
https://dev.mysql.com/doc/refman/9.7/en/charset-unicode.html
Attempting to use them with SET NAMES or SET CHARACTER SET produces an error. The Unicode Standard includes characters from the Basic Multilingual Plane (BMP) and supplementary characters that lie outside the BMP. For information about the Unicode ...