PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-reset-replica.html
To reset all currently configured replication channels: RESET SLAVE; To reset only a named channel, use a FOR CHANNEL channel clause: RESET SLAVE FOR CHANNEL "source_1"; For GTID-based replication, note that RESET SLAVE has no effect on the ... The ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-truncate-all-tables.html
Parameters in_verbose BOOLEAN: Whether to display each TRUNCATE TABLE statement before executing it. Truncates all Performance Schema summary tables, resetting all aggregated instrumentation as a snapshot. Example mysql> CALL ...
https://dev.mysql.com/doc/refman/5.7/en/upgrading.html
SQL statements can be executed using the mysql command-line client (connect as root to ensure that you have the necessary privileges). This section describes the steps to upgrade a MySQL installation. Upgrading is a common procedure, as you pick up ...
https://dev.mysql.com/doc/refman/5.7/en/workbench.html
As well as enabling you to configure connection parameters, MySQL Workbench provides the capability to execute SQL queries on the database connections using the built-in SQL Editor. MySQL Workbench provides a graphical tool for working with MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/activestate-perl.html
If you cannot get the procedure to work, you should install the ODBC driver instead and connect to the MySQL server through ODBC: use DBI; $dbh= DBI->connect("DBI:ODBC:$dsn",$user,$password) || die "Got error $DBI::errstr when connecting to $dsn\n"; ... On Windows, you should do the following to install the MySQL DBD module with ActiveState Perl: Get ActiveState Perl from http://www.activestate.com/Products/ActivePerl/ and install ...
https://dev.mysql.com/doc/refman/5.7/en/binary-installation.html
These include generic binary distributions in the form of compressed tar files (files with a .tar.gz extension) for a number of platforms, and binaries in platform-specific package formats for selected platforms. This section covers the installation ...
https://dev.mysql.com/doc/refman/5.7/en/connection-options.html
It is always enabled and attempting to disable it (--skip-secure-auth, --secure-auth=0) produces an error. This section describes options supported by most MySQL client programs that control how client programs establish connections to the server ...
https://dev.mysql.com/doc/refman/5.7/en/downgrade-before-you-begin.html
Use of new features, new configuration options, or new configuration option values that are not supported by a previous release may cause downgrade errors or failures. The backup should include the mysql database, which contains the MySQL system ...
https://dev.mysql.com/doc/refman/5.7/en/drop-index.html
These keywords are no longer supported in MySQL NDB Cluster 7.5 and later, and their use causes a syntax error. algorithm_option: ALGORITHM [=] {DEFAULT | INPLACE | COPY} lock_option: LOCK [=] {DEFAULT | NONE | SHARED | EXCLUSIVE} DROP INDEX drops ...
https://dev.mysql.com/doc/refman/5.7/en/drop-logfile-group.html
The log file group must already exist or an error results. DROP LOGFILE GROUP logfile_group ENGINE [=] engine_name This statement drops the log file group named logfile_group. (For information on creating log file groups, see Section 13.1.15, ...