Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-howto.html
To set up replication of a new source using the data from an existing MySQL server, see Section 19.1.2.6.2, “Setting Up Replication with Existing Data”. To add replicas to an existing replication environment, see Section 19.1.2.8, “Adding ...
https://dev.mysql.com/doc/refman/8.4/en/replication-mode-change-online-disable-gtids.html
Wait for all transactions that currently exist in any binary log to be committed on all replicas. Ideally, you should wait for the server to purge all binary logs that existed when step 5 was completed, and for any backup taken before then to expire. For this reason, before proceeding further, you must be sure that no uncommitted GTID transactions exist anywhere in the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rbr-usage.html
When a given client session ends, the server logs a DROP TEMPORARY TABLE IF EXISTS statement for each temporary table that still exists and was created when statement-based binary logging was in use. If row-based or mixed format binary logging was ... MySQL uses statement-based logging (SBL), row-based logging (RBL) or mixed-format ...
https://dev.mysql.com/doc/refman/8.4/en/reset-replica.html
(This is a condition likely to exist on a replica if you have issued a STOP REPLICA statement or if the replica is highly loaded.) For a server where GTIDs are in use (gtid_mode is ON), issuing RESET REPLICA has no effect on the GTID execution ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin-usage.html
Check the rewrite_rules table for rows with non-NULL message column values to see what problems exist. mysql> SHOW GLOBAL STATUS LIKE 'Rewriter_reload_error'; +-----------------------+-------+ | Variable_name | Value | ... To enable or disable the ...
https://dev.mysql.com/doc/refman/8.4/en/savepoint.html
If the ROLLBACK TO SAVEPOINT statement returns the following error, it means that no savepoint with the specified name exists: ERROR 1305 (42000): SAVEPOINT identifier does not exist The RELEASE SAVEPOINT statement removes the named savepoint from ... SAVEPOINT identifier ROLLBACK [WORK] TO [SAVEPOINT] identifier RELEASE SAVEPOINT identifier InnoDB supports the SQL statements SAVEPOINT, ROLLBACK TO SAVEPOINT, RELEASE SAVEPOINT and the optional WORK keyword for ...
https://dev.mysql.com/doc/refman/8.4/en/se-csv-repair.html
When running the CHECK TABLE statement, the CSV file is checked for validity by looking for the correct field separators, escaped fields (matching or missing quotation marks), the correct number of fields compared to the table definition and the ...
https://dev.mysql.com/doc/refman/8.4/en/server-options.html
If the file does not exist or is otherwise inaccessible, an error occurs. If the file does not exist or is otherwise inaccessible, an error occurs. If the existing installation data has a lower MySQL version than the server expects, it must be ...
https://dev.mysql.com/doc/refman/8.4/en/solaris-installation-pkg.html
(default: all) [?,??,q]: The PKG installer installs all of the files and tools needed, and then initializes your database if one does not exist. To upgrade when using the Solaris package file format, you must remove the existing installation before ... You can install MySQL on Solaris using a binary package of the native Solaris PKG format instead of the binary tarball ...
https://dev.mysql.com/doc/refman/8.4/en/sql-mode.html
Rows that duplicate an existing row on a unique key value are discarded. INSERT: With IGNORE, rows that duplicate an existing row on a unique key value are discarded. LOAD DATA, LOAD XML: With IGNORE, rows that duplicate an existing row on a unique ... The MySQL server can operate in different SQL modes, and can apply these modes differently for different clients, depending on the value of the sql_mode system ...