Search Results
https://dev.mysql.com/doc/refman/8.4/en/audit-log-logging-configuration.html
Connect to the server and flush the log file so the plugin closes it and reopens a new audit.log file: SET GLOBAL audit_log_flush = ON; audit_log_flush is special in that its value remains OFF so that you need not disable it explicitly before ...
https://dev.mysql.com/doc/refman/8.4/en/backup-and-recovery.html
A client application is connected to the primary via MySQL Router. It is important to back up your databases so that you can recover your data and be up and running again in case problems occur, such as system crashes, hardware failures, or users ...
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 ...