Search Results
https://dev.mysql.com/doc/refman/8.4/en/automatic-start.html
On Solaris, use the service management framework (SMF) system to initiate and control MySQL startup. This section discusses methods for starting and stopping the MySQL server. Generally, you start the mysqld server in one of these ways: Invoke ...
https://dev.mysql.com/doc/refman/8.4/en/backup-policy.html
It is more efficient to make an initial full backup, and then to make incremental backups. A full backup (a snapshot of the data at a point in time) can be done in MySQL with several tools. For example, MySQL Enterprise Backup can perform a physical ...
https://dev.mysql.com/doc/refman/8.4/en/change-replication-source-to.html
With SOURCE_AUTO_POSITION = 1 set, in the initial connection handshake, the replica sends a GTID set containing the transactions that it has already received, committed, or both. ] CHANGE REPLICATION SOURCE TO changes the parameters that the replica ...
https://dev.mysql.com/doc/refman/8.4/en/changing-mysql-user.html
(It is a good idea to assign passwords to MySQL accounts in any case, but especially so when other login accounts exist on the server host.) See Section 2.9.4, “Securing the Initial MySQL Account”. On Windows, you can run the server as a ...
https://dev.mysql.com/doc/refman/8.4/en/charset-collation-information-schema.html
Note It is prohibited to start the server with a lower_case_table_names setting that is different from the setting used when the server was initialized. String columns in INFORMATION_SCHEMA tables have a collation of utf8mb3_general_ci, which is ...
https://dev.mysql.com/doc/refman/8.4/en/charset-conversion.html
If you specified attributes when creating a column initially, you should also specify them when altering the table with ALTER TABLE. To convert a binary or nonbinary string column to use a particular character set, use ALTER TABLE. For successful ...
https://dev.mysql.com/doc/refman/8.4/en/charset-server.html
Initially, the server character set and collation depend on the options that you use when you start mysqld. 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 ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-failure-handling.html
If the data is of importance, a backup should be taken before initiating a remote cloning operation. This section describes failure handing at different stages of a cloning operation. If a failure occurs during the prerequisite check, the CLONE ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-monitoring.html
When a clone operation is initiated, the different statement types tracked by clone statement instruments may be executed in parallel. You can monitor the status and progress of a cloning operation on the recipient MySQL server instance using the ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-options-variables.html
If values specified at startup are incorrect, the clone plugin may fail to initialize properly and the server does not load it. This section describes the system variables that control operation of the clone plugin. In this case, the server may ...