PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/perl-support-problems.html
If Perl reports that it cannot find the ../mysql/mysql.so module, the problem is probably that Perl cannot locate the libmysqlclient.so shared library. You should be able to fix this problem by one of the following methods: Copy libmysqlclient.so ...Note that you may also need to modify the -L options if there are other libraries that the linker fails to ...
https://dev.mysql.com/doc/refman/8.0/en/reloading-delimited-text-dumps.html
For backups produced with mysqldump --tab, each table is represented in the output directory by an .sql file containing the CREATE TABLE statement for the table, and a .txt file containing the table data. To reload a table, first change location ...
https://dev.mysql.com/doc/refman/8.0/en/rename-table.html
As of MySQL 8.0.13, you can rename tables locked with a LOCK TABLES statement, provided that they are locked with a WRITE lock or are the product of renaming WRITE-locked tables from earlier steps in a multiple-table rename operation. For example, ... RENAME TABLE tbl_name TO new_tbl_name [, tbl_name2 TO new_tbl_name2] ...
https://dev.mysql.com/doc/refman/8.0/en/replication-administration.html
Tip To deploy multiple instances of MySQL, you can use InnoDB Cluster which enables you to easily administer a group of MySQL server instances in MySQL Shell. InnoDB Cluster wraps MySQL Group Replication in a programmatic environment that enables ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-reserved-words.html
You can encounter problems when you attempt to replicate from an older source to a newer replica and you make use of identifiers on the source that are reserved words in the newer MySQL version running on the replica. For example, a table column ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-assign-anon.html
From MySQL 8.0.23, you can set up replication channels to assign a GTID to replicated transactions that do not already have one. Note that as is standard for MySQL replication, this feature does not support replication from MySQL source servers ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-restrictions.html
Because GTID-based replication is dependent on transactions, some features otherwise available in MySQL are not supported when using it. This restriction is lifted in MySQL 8.0.21 on storage engines that support atomic DDL. From MySQL 8.0.13, when ...This section provides information about restrictions on and limitations of replication with ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto-repuser.html
Each replica connects to the source using a MySQL user name and password, so there must be a user account on the source that the replica can use to connect. The user name is specified by the SOURCE_USER | MASTER_USER option of the CHANGE ...Any ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto-slaveinit.html
You must be able to connect to the source MySQL server using TCP/IP. To set up the replica to communicate with the source for replication, configure the replica with the necessary connection information. The CHANGE REPLICATION SOURCE TO | CHANGE ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options.html
The following sections contain information about mysqld options and server variables that are used in replication and for controlling the binary log. server_uuid The MySQL server generates a true UUID in addition to the default or user-supplied ...