PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysqlcheck.html
(This is also true for the MySQL upgrade procedure if it determines that table checking is needed because it processes tables the same way.) mysqlcheck must be used when the mysqld server is running, which means that you do not have to stop the ...
https://dev.mysql.com/doc/refman/5.7/en/ndb-restore-to-different-version.html
Since it is possible to restore metadata and table data separately, you can in such cases restore the table schemas from a dump made using mysqldump, or by executing the necessary CREATE TABLE statements manually, then import only the table data ...
https://dev.mysql.com/doc/refman/5.7/en/postinstallation.html
This section discusses tasks that you should perform after installing MySQL: If necessary, initialize the data directory and create the MySQL grant tables. For other platforms and installation types, you must initialize the data directory manually.
https://dev.mysql.com/doc/refman/5.7/en/problems-connecting.html
For distributions that do not do this, you must initialize the data directory manually. To correct this when you invoke a client program, specify a --port option to indicate the proper port number, or a --socket option to indicate the proper named ... If you encounter problems when you try to connect to the MySQL server, the following items describe some courses of action you can take to correct the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-bugs.html
In this case, the replication SQL thread stops and waits for you to clean up the tables manually to bring them into synchrony. When you have determined that there is no user error involved, and replication still either does not work at all or is ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-invoked.html
For example, trying to replicate a loadable function with statement-based replication generates this warning because it currently cannot be determined by the MySQL server whether the function is deterministic. In the case of CREATE EVENT and ALTER ... Replication of invoked features such as loadable functions and stored programs (stored procedures and functions, triggers, and events) provides the following characteristics: The effects of the feature are always ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features.html
If you are planning to use statement-based replication between MySQL 5.7 and a previous MySQL release series, it is a good idea to consult the edition of the MySQL Reference Manual corresponding to the earlier release series for information ... The ...
https://dev.mysql.com/doc/refman/5.7/en/replication-howto-masterstatus.html
Warning This procedure uses FLUSH TABLES WITH READ LOCK, which blocks COMMIT operations for InnoDB tables. If you are planning to shut down the source to create a data snapshot, you can optionally skip this procedure and instead store a copy of the ... To configure the replica to start the replication process at the correct point, you need to note the source's current coordinates within its binary ...
https://dev.mysql.com/doc/refman/5.7/en/replication-problems.html
Many users have lost time by not doing this soon enough after encountering problems. This should never happen if you have taken a proper snapshot of the source, and never modified the data on the replica outside of the replication threads. If the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-upgrade.html
In this way you will never be in the situation where a replica still at the earlier release is attempting to handle transactions from a source at the later release. This restriction applies not only to release series, but to version numbers within ... When you upgrade servers that participate in a replication topology, you need to take into account each server's role in the topology and look out for issues specific to ...